excel 2002 build problem...

[Ole Einar Ranengen]

I have written a source code i excel VBA. I have Excel 2002. When I try to
open this wirkbook in older build versions of excel I get an error: Error in
compilation hidden module, and error in compilation module1.
Are there any way to make a code backward compatible to older builds or
anything else that can solve my problem.

Ole

 

[John]

Ole,
This is a MS Project VBA newsgroup. However, I would try the following.
First, copy the module code from Excel 2002 to the clipboard. Next, open
a new workbook in the older version of Excel and create a new module.
Then, paste the clipboard into the new module. Finally, run the macro.
If there are compatibility issues, you should get error messages telling
you what to change.

I have done some work with Excel objects but I do not know if there are
any compatibility issues between versions. If the suggestion above does
not work, you might try the microsoft.public.excel.programming newsgroup.

Good luck.
John