Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Compatability Excel 2007 vs Excel 97 - 2003
I'm developing a spreadsheet with seral macros using Excel 2007. I want the
spreadsheet compatible with Excel 97 - 2003, so I've been saving the file in that format. When I tried to test the macros on another computer using Excel 2003, the program stopped because it didn't recognize some of the code. My question is, is there a way to know an object in VBA 2007 is (or is not) compatible with earlier versions of excel? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Compatability Excel 2007 vs Excel 97 - 2003
It is usually advisable to develop your code on the oldest system you intend
to support. That way, additional arguments added in later versions, which are normally optional, take their default values. You should still test on the newer system though. XL2007 does have some differences, especially regarding Charts and objects on the drawing layer, as mentioned in posts here. NickHK "Microsmith" wrote in message ... I'm developing a spreadsheet with seral macros using Excel 2007. I want the spreadsheet compatible with Excel 97 - 2003, so I've been saving the file in that format. When I tried to test the macros on another computer using Excel 2003, the program stopped because it didn't recognize some of the code. My question is, is there a way to know an object in VBA 2007 is (or is not) compatible with earlier versions of excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 macro compatability | Excel Discussion (Misc queries) | |||
Excel 2003 to Excel 2007 Compatability | Excel Discussion (Misc queries) | |||
Excel 2007 compatability mode, can't open when saved by excel 2003 | Excel Discussion (Misc queries) | |||
Excel compatability 2003-2007 | Setting up and Configuration of Excel | |||
Macro runs in Excel 2003, bombs in XP - Compatability question | Excel Programming |