VBA Excel - .Copy

[hsummer]

I wrote an application using Excel2000 and I want to use it on Excel97. It saves sheets of a workbook as separate files. It works on my computer but on another computer I get the error that the class is invalid.

Why would that be?

Harold

 

[BrainB]

Check under Tools/References in the VB Editor. You may find differences there.

I think we would all be grateful if you would publish your results here. I have just started using Excel 2000 from 97 and would like to be aware of possible pitfalls such as you have discovered. Regards
BrianB
** Let us know if you get something that works !
================================