vba project for excel 2000 not visible in excel 97

[Enkay62]

Hi.
I've built an excel 2000 wb and it works perfectly on my pc (excel 2000).
My end user has excel '97 and when I run my workbook there are some problems (maybe some variables types are not yet included in excel '97).
My problem is that when errors occur I cannot do any debug because my vba project (excel 2000) is not visible in excel '97 ( even if unprotected).
What can I do?
Any suggestion will be apreciated.
Thank you.
Bye.
Nick.

 

[RobSchultz]

You should probably create the spreadsheet in Excel 97 and program to the lowest common denominator. There are a lot of functions in 2000 that aren't available in 97 (instrev, split, join, addressof, non-modal forms, etc). You can get around them using some custom functions that mimic the ones that are missing. As for the project not showing up, it may be that the person that has 97 doesn't have the same VBA runtime that you have. Open Tools->References and look at the version and location of the Visual Basic for Applications component. If the other person doesn't have the same one this you'll need to upgrade them to do any troubleshooting. There is also a slight "binary" difference in the file structures between the two versions (as evidenced by exporting a form/module from 2000 and trying to import it into 97)

HtH,

Rob

-Focus on the solution to the problem, not the obstacles in the way.-

 

[Enkay62]

Hi Rob. Thank you for answering.
Do you mean that if I export all forms and modules from excel 2000 and after import them in excel '97 they will not be visible?
Thank you.
Nick

 

[Enkay62]

What happens to vba project if I save the wb in '97 format?
Thanks.

 

[combo]

Has the workbook been marked as 'shared' in the meantime? It blocks some excel functions, including viewing vba project.

combo

 

[Enkay62]

Hi Combo.
No, the file hasn't been marked as "Shared".
The problem, in fact, occurs immediately as soon as I open it after installation.
I knew that an excel 2000 project is not visible if you open or save the file in excel 5, but didn't know it would happen even between exc 2000 and '97 which are, all in all, so similar.
Any idea?
Thanks
Nick.

 

[Chattin]

Posted in your other thread but just to be sure I'm afraid you'll need to unlock it in a later version.

See this link for more info:

http://support.microsoft.com/defaul...port/kb/articles/Q229/4/99.ASP&NoWebContent=1

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help