T
Tom Sinclair
Hi.
I have a spreadsheet that crashes the first time it is used on all versions
of Excel (97 - 2003). The error it gives is "Method or data member not
found." and code for a combobox is highlighted.
After the first crash, I save it and close it and thereafter it works no
problem. Everytime I overwrite the files with the originals then I have to
go through the same process to get it working.
Background:
We have a spreadsheet that we distribute to our clients. The spreadsheet was
origanally developed using Excel 97. I am now using Excel 2000 SP3 for the
development work.
Once the needed changes have been made to the original Excel files. I open
them in Each version of Excel (97 to 2003), Choose "Save As", and save in
the Native Excel format for that version. I presume this should save the
file (originally in Excel 2000 format) in the destination version of Excel
97, 2002, 2003 (for example). The files are then packaged into a setup
program. As explained above the first time you use it, it crashes with the
error "Method or data member not found." while trying to reference a
combobox. After saving it and closing it, it works fine, until you uninstall
and reinstall using setup, which effectively replaces the files with the
originals in the setup program, then it does the same thing.
The entire spreadsheet consists of one main spreadsheet (.xls) and two
linked spreadsheets saved as Excel Add-ins (.xla). One of the xla files
provides some global VBA functions and the other the data. The spreadsheets
contain VBA, user forms, and controls placed directly on the worksheets.
I am out of idea's.
Thanks in advance for any help,
Tom
PS: Excel 97 keeps giving me the error "File created in later version of
Excel" when I open it in Excel 97, even after I saved it in Excel 97 format.
How can I get rid of this?
I have a spreadsheet that crashes the first time it is used on all versions
of Excel (97 - 2003). The error it gives is "Method or data member not
found." and code for a combobox is highlighted.
After the first crash, I save it and close it and thereafter it works no
problem. Everytime I overwrite the files with the originals then I have to
go through the same process to get it working.
Background:
We have a spreadsheet that we distribute to our clients. The spreadsheet was
origanally developed using Excel 97. I am now using Excel 2000 SP3 for the
development work.
Once the needed changes have been made to the original Excel files. I open
them in Each version of Excel (97 to 2003), Choose "Save As", and save in
the Native Excel format for that version. I presume this should save the
file (originally in Excel 2000 format) in the destination version of Excel
97, 2002, 2003 (for example). The files are then packaged into a setup
program. As explained above the first time you use it, it crashes with the
error "Method or data member not found." while trying to reference a
combobox. After saving it and closing it, it works fine, until you uninstall
and reinstall using setup, which effectively replaces the files with the
originals in the setup program, then it does the same thing.
The entire spreadsheet consists of one main spreadsheet (.xls) and two
linked spreadsheets saved as Excel Add-ins (.xla). One of the xla files
provides some global VBA functions and the other the data. The spreadsheets
contain VBA, user forms, and controls placed directly on the worksheets.
I am out of idea's.
Thanks in advance for any help,
Tom
PS: Excel 97 keeps giving me the error "File created in later version of
Excel" when I open it in Excel 97, even after I saved it in Excel 97 format.
How can I get rid of this?