T
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
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