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


Replace @mailinator.com with @tiscali.co.uk


"Jeff" wrote in message
...
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.