VB6 and VBA on a Vista 64-bit computer

[Ted Mercer]

I have just bought a Vista 64-bit computer after hearing that 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: Stand alone VB6 application was OK.
Existing Word files are OK. 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

 

[Clif McIrvin]

Not an answer to your question, but can you use the Excel
Application.WorksheetFunction Object to perform your calculations
directly from VB6 instead of using the .xls worksheet?

 

[Ted Mercer]

Clif:

Thanks for your suggestion. My project is an engineering application where
extensive calculations are done by the spreadsheet making use of VBA
macros. VB6 provides the user interface, collecting and exporting the user
input, importing the results and then displaying them.

Ted

 

[Clif McIrvin]

I had no idea if that was a reasonable suggestion or not. I have
tinkered with the Application.WorksheetFunction object a little bit to
gain access to Excel functions from within MS Access, and at least some
worksheet functions will accept a VB Array where they would normally
expect a worksheet range. Failing an easier solution it seemed
worthwhile to toss the idea out.

--
Clif

Clif:

Thanks for your suggestion. My project is an engineering application
where
extensive calculations are done by the spreadsheet making use of VBA
macros. VB6 provides the user interface, collecting and exporting the
user
input, importing the results and then displaying them.

Ted