excel

Disable the Research Task Pane in Excel/Office

Hi all, Can how I disable the Research Task Pane in MS Excel/Office 2003? Thanks for your help in advance, Donald ...

Programmatically exclude page items in olap pivot

I have a pivot table on an olap cube. I can go into a page field and manually deselect multiple items. How can I do this in VBA based on a list of items I need excluded? (n.b. I do not have a corrresponding list of items I need included) I know how to exclude these items in other ways, by altering the underlying query for example. I spe...

Alternative to Excel's RefEdit control that can be used outside of VBA

The RefEdit control that comes as part of VBA is a little buggy, but it's good for putting on a form when you want people to specify one or more ranges of cells (i.e. Excel.Range objects). The main problem is that you can only use the RefEdit control on a VBA UserForm (Microsoft states this, and my tests confirm it too). I'm making an ...

How to apply bold style to a specific word in excel file , using python ?

hi , i am using pyexcelerator python module to generate excel files, i want to apply bold style to part of cell text, but not to the whole cell. how to do it ? ...

Finding Cell Range With Excel Macros

I have an many embedded objects (shapes) in a worksheet and the icons is displayed inside a cell. How do I know the Cell range in which the shape object is displayed. for eg : When I select a Cell B2 and then select the object(shape) in the cell B17, and I query on the Cell.Address it shows B2. How will I get the cell address as B17. ...

how do i determine the number of rows in a range in excel using VBA

in my code i know the range name of the start of a list - 1 column wide x rows deep how do i calculate x? there is more data in the column than just this list, however this list is contiguous - there is nothing in any of the cells above or below or either side beside it ...

What is a good reference for how calculation engines such as Excel work?

I am interested in learning how dependency-based calculation engines work in practice. Of course, I can make up my own algorithm, but I was curious if there were any well explained algorithms that are used in practice. I have tried Google, but most articles are < "good". ...

How do I read an Excel file into Python using xlrd? Can it read newer Office formats?

My issue is below but would be interested comments from anyone with experience with xlrd. I just found xlrd and it looks like the perfect solution but I'm having a little problem getting started. I am attempting to extract data programatically from an Excel file I pulled from Dow Jones with current components of the Dow Jones Industrial...

Generate Dynamic Excel from Java

We've pre-defined Excel document structure with lots of formulas and macros written. During download of Excel, thru Java application we populate certain cells in Excel with data. After download when user open Excel, macros & formulas embedded in it will read the pre-populated data and behave accordingly. We are rightnow using ExtenXLS ...

Load Excel data sheet to Oracle database

I am looking for a free tool to load Excel data sheet into Oracle database. I tried oracle sql developer, but it keeps throwing NullPointerException. Any ideas? ...

How to work around the [1] IE bug while saving an excel file from a Web server ?

I've noticed that Internet Explorer adds a number in square brackets to files downloaded from the internet (usually [1]). This creates a big problem with downloading Excel spreadsheets as square brackets are not a valid filename character inside Excel worksheet name. That problem is IE specific, others browsers are keeping same file name...

Expose VSTO functionality to VBA w/o local admin

What would be the best way to expose certain functionality in a Dotnet VSTO Excel add-in to VBA, without requiring the user to be a local administrator (i.e. no COM registration, no HttpListener)? Would it be possible to use Microsoft Message Queues from VBA? ...

How do you get a spreadsheet to open Excel instead of a browser window?

If you call javascript window.open and pass a url to a .xls file it open on some machines in the browser window. How can you force it into Excel? ...

LabVIEW holds Excel Reference

Hi, I try to open and excel reference in LabVIEW and then close it after sometime. But the LabVIEW keeps holding the reference and does not release it unless I close the VI. Why is this happening? Is there anyway to force it to release the Reference? I am checking the error out for any errors. But it is not throwing up any errors. ...

How to tell if an Excel Workbook is protected

I can use properties of an Excel Worksheet to tell if the worksheet is protected (Worksheet.Protection, Worksheet.ProtectContents etc). How can I tell using VBA if the entire workbook has been protected? ...

Change datatype when importing Excel file into Access

Is there any way to change the defaulted datatype when importing an Excel file into Access? (i'm using Access 2003, by the way) I know that I sometimes have the freedom to assign any datatype to each column that is being imported, but that could only be when I'm importing non-Excel files. EDIT: To be clear, I understand that there is ...

MSExcel 2002 calling Web Services.

What is the easiest way to call a web service from Excel (I am using version 2002)? Please, no third party tools or libraries. This has to be easy with some VBA that I can paste there, use it, and ever touch. ...

Can you connect to sql server from Excel?

Hi, I need to create some reports from a sql server database for end users to view. Is it possible to hook into sql server from excel? Update The end user will only click on the file to view the reports, asking them to do more is too much to ask! ...

What causes "Invalid advise flags" run-time error in Excel VBA?

I have a Excel macro that generates a this error whenever it gets input of a specific format. Does anyone knows in general what an advise flag is OR where can I find information on this type of error? Thanks Runtime error -2147221503 (80040001): Automation error, Invalid advise flags ...

How to create Excel 2003 UDF with a C# Excel add-in using vsto 2005 SE

I have seen this http://blogs.msdn.com/pstubbs/archive/2004/12/31/344964.aspx. However i want to get this working in C# Excel add-in using vsto 2005 SE, can any one help? ...