Making a project backwards compatible

I created a project in Excel 2007 and discovered that would not open in Excel 2003. It makes sense, but I would like to be able do just that. This project uses traditional functions and formulas, as well as vba macros and user forms. I'm not sure how to go about converting. Any suggestions would be appreciated.
Thanks, bill

Hi bhsoundman

I have your same requirement and issues often, so here is my advise..
You are likely only going to be able to do what you are asking by converting the .xlsm or .xlsb workbook file to: a 97-2003 .xls workbook using the save as file type drop down list in Excel 2007 (save as 97-2003 .xls is on that list). When you do this you will likely get warnings that some of your macros and formulas will not work in 2003, but just click ok to that, as very often they work fine.

I'm far from an expert, but I doubt that it's possible to use a 2007 .xlsm or .xlsb workbook file on both Excel 2007 and Excel 2003 and have the macros work with Excel 2003.

* On the other hand, I often successfully use .xls files with macros on both 2003 and 2007(with some macro security adjustments)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
it's been my experience that the conversion tool supplied by MS, that allows you to open a .xlsm from Excel 2003 , is often going to give you the issue's you described. --- Even when I have used that conversion tool to save the file from .xlsm to .xls , I have some times found issues with macro errors.

It's important to note that once the conversion is done using the conversion tool, the file is often damaged and that damage may be time consuming to undo, even with excel 2007
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Hope that helps

Thanks for the input. I'll give it a try. :D

Also take note that a few cell background, or shades, or font colors in 2007 are not available in 2003, so those will always give you errors. To make those parts of your code become compatible with both, you can often just run the macro recorder in 2003 to discover suitable replacement syntax.

There are also sometimes small differences in sorting syntax and probably a few others, but it is rare, as I haven't run across others yet, and I have spent at least 5 to 8 hours coding each month in Excel 2007, over the last year... (I have several years coding experience in 2003 and many semi-complex apps that I converted with very little effort to work in 2007)...

The only command I've heard of that works in 2003 but not 2007 is application.Filesearch http://support.microsoft.com/kb/920229. I imagine there might be a couple others, but it is rare.

Of course it goes without saying that when code needs to run on both newer and older versions it will save time and some headaches to develop in the earlier version.