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.

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.

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

"Sandy Mann" wrote:

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.

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 he

http://en.allexperts.com/q/Excel-105...os-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


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


"Jeff" wrote in message
...
Yes, I get VBA errors when I run it such as '1004'.

"Sandy Mann" wrote:

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.