PDA

View Full Version : Excel 2003 vs 2000



drizza
07-12-2006, 04:21 PM
I have an excel file that was created using excel 2003 and now want to use it in excel 2000. I have a lot of VB code in the file. I tested a few of my radio buttons the use Visual basic created in excel 2003 and they did not work in 2000. What is the best way to update/change the VB code to have it work in excel 2000? What were the major updated from 2000 to 2003 that may result in the file not funtioning in 2000.

Thanks in advance.

Bob Phillips
07-12-2006, 04:39 PM
I have an excel file that was created using excel 2003 and now want to use it in excel 2000. I have a lot of VB code in the file. I tested a few of my radio buttons the use Visual basic created in excel 2003 and they did not work in 2000. What is the best way to update/change the VB code to have it work in excel 2000? What were the major updated from 2000 to 2003 that may result in the file not funtioning in 2000.

Thanks in advance.

Always develop in the lowest deployment version. That way you avoid such problems.

mdmackillop
07-12-2006, 11:56 PM
Hi Drizza,
Welcome to VBAX
I've a workbook I use in two locations, with 2000 and 2003. My only problem is that I keep losing my Form Command buttons off the worksheets. Sounds like yours may be similar.
In actual code function, the only problem I've come across is

Range("A1:H20").Sort Key1:=Range("D1"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

recorded in 2003. Delete the DataOption to make it 2000 compliant. I'm sure there are others, but not that I've encountered.

drizza
07-17-2006, 02:48 PM
Thanks.