Excel 5 on Windows XP (2)

  • Thread starter Thread starter Roger Bedford
  • Start date Start date
R

Roger Bedford

I've installed Excel 5 on Windows XP with Office XP installed as well. I'm
having a lot of trouble with various macro functionality. When I try to run a
macro in Excel 5 that is not very basic I get the following message:
'Run-time error '1004'; Work03.xls: file format is not valid'. However if I
have a very basic macro it will run. Another problem is that some auto-open
macros run part way and then just stop without showign an error message.

Has anyone out there tried the same? If so, have you run into similar
problems? How were they resolved?

Any suggestions will be greatly appreciated,

Roger
 
Hi Roger,
Another problem is that some auto-open
macros run part way and then just stop without showign an error message.
Click to expand...

Dunno about your other problem. I do know XL5 used to be picky about the
length of code in Auto_Open. Best to break that by making a sub called
ContinueOpen and have this single line in Auto_Open:

Application.Ontime Now, "ContinueOpen"

And no, calling another sub normally be direct reference is not enough...

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Hi Jan, many thaks for your suggestion. I've been swamped so will now try
your suggestion. Thanks for the help.

Roger
 
Back
Top