Excel applications that run in both XP/2003 and Vista

[jlefebvre]

I have several Excel applications that run fine in XP/2003.

I know at some point I will need to re-write them to run in Excel Vista.

Have others had success re-writing applications for Vista, yet maintaining compatibility in XP/2003?

Thanks.

Jeff

 

[Lewiy]

I think generally the compatibility between Office 2003 and 2007 is pretty good. The immediate thing that comes to mind would be VBA commands like:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Cells(65536,1).End(xlUp).Row<o></o>
<o> </o>
Which would now need to reflect the new maximum row value. However, this is solved with Rows.Count as a replacement for 65536.<o></o>
<o> </o>
The problems you are more likely to have is using workbooks in 2003 that were written in 2007, but you can save 2007 files as a backward compatible file types anyway so that should be fine. I’ve not experienced any real problems with flicking between the two so far.

 

[Jonmo1]

One of the complains I've seen the most is they removed Application.Filesearch from 2007.

But you can use Dir instead..

 

[jlefebvre]

Thanks.

My main concern is probably the User Interface. The XP/2003 applications use toolbars/commandbars (and they tend to hide all Excel functions/menus).

When I convert for Vista I'll have to use Ribbons or something else. Using the Addin Ribbon is not an option since my applications need to look like stand alone applications, not jazzed up Excel spreadsheets.

Once I code for an interface without toolbars/commandbars and the new UI, how will that application then work again back in XP/2003?