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.