2003 to 2007 excel compatibility

[ABabeNChrist]

I have a workbook that uses VBA and was created using excel 2007, is there a free download that will help excel 2003 read and use this 2007 workbook?

[HansV]

Yes: see Download details: Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats. It's a free download from Microsoft, and it works with Office 2000 SP3, Office XP SP3 or Office 2003 SP1 or later, on Windows 2000, XP, 2003, Vista or 7.

[ABabeNChrist]

You are awesome Hans
Thank you

[StuartR]

A simpler alternative might be to simply save the workbook as am Excel 97-2003 Workbook (*.xls) from within Word 2007.

[ABabeNChrist]

]
Hi StuartR
If I were to save my current workbook that was developed using 2007 to Excel 97-2003 Workbook (*.xls) will all my previous VBA still run on 2003. Or will there be problem for 2003

[StuartR]

...will all my previous VBA still run on 2003. Or will there be problem for 2003

That depends on whether you have used any functionality that is new for Office 2007, but if this is the case then the file converters that Hans suggested won't help either.

Best practice is to develop and compile your VBA code on the earliest version that you want to support.

[ChrisGreaves]

... develop and compile your VBA code on the earliest version that you want to support.

Agreed (Since this is what I do!). Office 2000 is the development platform, since some clients still use this.
As noted in This Thread even 2000/2002/2003 compatible VBA can be tripped over in 2007.
I have a new wrinkle - simple code (I feel) that is developed here in 2000, runs on my 2002/2003 systems, but falls over on 2007 systems in Boulder Colorado, of all places.
Yesterday I installed office 2010 on a WinXP-SP3 machine here and the same code installed and ran flawlessly.

It seems to me that there have been some "minor" changes made in the VBA interpreter in 2007 and 2010, and they are waiting to leap out at us from dark and scary places.

[Wendell]

If you lived as close to Boulder as I do, you would know that strange things happen there all the time!