Excel 97

[Jeff]

I just got thrown a random assignment at work of making Excel spreadsheet
made in 97 work with Excel 2007. I have ZERO experience with any form of VB
(I have a C background).

First, is there anyway make Excel 2007 backwards compatible with Excel 97
code. This, of course, would be the simplest solution.

Second, if I have to update the code, how should I approach this with no VB
experience? Should this require drastic changes, a complete rewrite, or only
minor fixes? I know this can vary case-by-case, but I am looking for
generalities right now.

 

[Sandy Mann]

What happens when you try to run an XL97 sheet in 2007? Do you get VBA
errors?

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Jeff]

Yes, I get VBA errors when I run it such as '1004'.

 

[Sandy Mann]

I only have XL97 but there should normally be no problem running Macros in
XL2007 that run in previous versions with very few exceptions. One
exception is listed here:

http://en.allexperts.com/q/Excel-1059/Excel-VBA-Macros-Vista-1.htm

If this does not apply try posting a section of the code that is returning
the error and perhaps some of the experts around here who have XL2007 will
advise.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk