EXCEL97 to 2002

[Schlogg]

Have a set of Excel files originally created with Excel 97 on WIN95 or 98.
Two large macros in a master spreadsheet. A 'customer' template used to generate customer files whose vales are linked to the Master, where they are totalled in various ways.
Pat of the solution involves defining, in a macro, a hyperlink to the Master.
We've just upgraded to XP and Excel2002. Two problems emerge.
1. Cannot persuade the system to let me see the macros. It just comes up with an empty list. BUT, if something goes wrong, and I debug, they appear.
2. This is the really weird bit. The macro is in the Master; its button is in the customer template - I cannot remember why.
We gave up on letting the macro generate the hyperlink and hardwired it.
Clicking on the hyperlink takes us to the Master.
Running the script, which should take us to the Master, generates the error -
"Unable to open ... blah blah blah ...
Make sure the path does not contain the characters < > [ ]
Crop 2003-4 Master.xls or *.&quot;
&quot;Crop 2003-4 Master.xls&quot; is the Master filename. (Not sure about the special characters. XP seems to be more forgiving on special characters in filenames?)
I recorded a macro to go to, and activate, the hyperlink just to check if MS had changed the coding - it's identical.

Any suggestions, apart from hemlock, would be greatly appreciated.


Cheers,
Paul J.

 

[dkriese]

take a look at this site

http://www.j-walk.com/ss/excel/faqs/xl97faq1.htm

John Walkenbach who wrote the Excel Bible has alot of good tips

you may need to re-write the macro in VBA, however, are users still using 97? in other words, are users using both versions of Excel?

 

[Schlogg]

Negative on using both versions.
I'll check out the site. Thanks.

Cheers,
Paul J.