App with VBA Macros on 64-bit Computer

[Ted Mercer]

I have just bought a Vista 64-bit computer after hearing that Excel
spreadsheets and VB6
applications would run on it. This I have found to be true but it is not
true for VBA macros running within Excel

Here is my experience to date: Existing Excel files (.xls) are OK, unless
they contain VBA macros. In the latter case, attempting to open the file
triggers an error message to the effect that "the VBA project in this file
requires a component that is not currently installed. The file will be
opened without the VBA project. For more information search Microsoft
Office Online for "VBA Converters"". Stripping out the macros makes the
file useless. Furthermore, I can find no applicable information online. Why
did Microsoft not provide the component as an add-in or say how it can be
obtained.?

My VB6 application calls an Excel spreadsheet (.xls, with VBA macros) to
do calculations on data exported to it and to return the results. I have
run all examples as administrator.

Should someone know of a solution, I would very much appreciate hearing.

Ted Mercer

 

[zodiac711]

Ted,

I just tried opening an Excel 2003 file I have (with VBA macros) on a Win
Vista x64 system (running Excel 2008). The file opened up just fine, but the
macro's were disabled. I enabled macro's running on the PC, re-opened the
file and it opened without a hitch. I then ran one of the macro's and it
worked flawlessly.

This would lead me to believe one of the following:
* When you installed Excel on your 64-bit system, there was an option that
you failed to install.
* The macro in question is linking to some add-on product which is not
installed on your system.
* You didn't specify which version of Excel you're running on the 64-bit
system -- presuming it's Excel 2003 (or earlier), perhaps there is some sort
of incompatibility. (The only 64-bit system I have is running Excel 2008.)

Best of luck.