Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 versus Excel 2002 question
Hi all,
I really hope someone can help me. I wrote some VBA code in Excel 2000 that doesn't work properly in Excel 2003. I'm not doing anything fancy, just basically looping through a .csv file and determining to which column and cell the data should be placed. I can certainly step through the code in 2003 to see what's going on. I'm just wondering if there are any known issues between the versions. For example, I use variables without having assigned a value to them (i.e., var = Empty). This works as expected in 2000, but I'm thinking that 20003 doesn't like that. Any other ideas would be greatly appreciated. Thanx. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 versus Excel 2002 question
Nothing leaps off the page. xl2002/2003 added some options for specifying
delimiters and so forth, so perhaps your default settings are inconsistent with what xl2000 was doing (if you data was parsed properly on opening the file xl2000, it may now all be in one column). -- Regards, Tom Ogilvy "Carla" wrote in message ... Hi all, I really hope someone can help me. I wrote some VBA code in Excel 2000 that doesn't work properly in Excel 2003. I'm not doing anything fancy, just basically looping through a .csv file and determining to which column and cell the data should be placed. I can certainly step through the code in 2003 to see what's going on. I'm just wondering if there are any known issues between the versions. For example, I use variables without having assigned a value to them (i.e., var = Empty). This works as expected in 2000, but I'm thinking that 20003 doesn't like that. Any other ideas would be greatly appreciated. Thanx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 versus 2003 and the TEXT Function | Excel Worksheet Functions | |||
Question about XML functionality (add-ons?) in Excel 2000 & 2002 | Excel Discussion (Misc queries) | |||
Excel 2003 versus 2002 seem incompatible related to the EDATE fun. | Excel Worksheet Functions | |||
Can you use excel 2003 version with excel 2002 and 2000 on a netw. | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) |