Using an Excel 2003 on Excel 2010

[matty1973]

Hi,

Some years a go I wrote a Excel 2003 spreadsheet that produces CSV files every few seconds for someone else. They now want to use the same spreadsheet with Excel 2010. They say because 2010 is multi threaded not single threaded and it will put less pressure on the servers.

I don't understand what this means. If someone could explain what this means and if there are likely to be any compatibility issues with using a 2003 spreadsheet on 2010 then I would be very grateful. I don't have 2010 so am unable to test if the sheet will even open.

Many thanks for any general ideas/advice for areas that might cause compatibility problems.

Matt

 

[Andrew Poulsom]

Multi-threading is explained here:

http://msdn.microsoft.com/en-us/library/bb687899.aspx?ppud=4

I don't think that should cause you any problems.

 

[Richard Schollar]

VBA is only single threaded in all versions of Excel so this should not impact your coding. There are some differences between the code but these are generally limited. We can point out obvious incompatibilities if you post up your code.

 

[matty1973]

Thanks for all the informative replies.

I have now purchased a copy of 2010 as done a full run through and as far as I can see there is no difference as when the file is run on 2003 - much as you guys said.

I've asked them to clarify what difference they are experiencing and will report back if there is indeed a compatibility issue - my feeling now though is there is not.

Many thanks