Excel 2007 or earlier version?

[1900b]

Hi Guys,

I'm new at the forum and have been looking around some time now and are amazed with the potential of the combination with excel. This made me eager to study some VBA, which also may come in handy at the office
VBA appears to be different between excel 2007 and earlier versions, so I need to make a choice which on to use. I suppose as you all have you libraries with old code from earlier versions u use excel xp/2003. What do you suggest?

Cheers,
Matt 1900B

[xraymitch]

Hi Matt,

Welcome

I use the same VBA code with Excel 2003 and 2007, so far without any problems.

I strongly suggest you go for 2007.

Cheers,

Ray

[Roger]

If this is a question about which product to buy, you should be aware that a) the initial release of Excel 2007 had several bugs, I believe, although these may have been fixed by now. And b) although VBA may be compatible with code written in previous versions, Excel 2007 was reported to be minimising the importance of VBA, so it may not be as easy to learn and use VBA in the later product. I would do some research before you spend the money.

If you are going to provide spreadsheets for other users, note that formulas written in Excel 2007 are not necessarily compatible with earlier products, and indeed nor is VBA code. Even Excel 2003 spreadsheets have this problem with macros. For this reason, I still use Excel 2000 so that my spreadsheets are compatible with later versions.

From other points of view, 2007 would be the way to go, because of the improvements in spreadsheet size limits, cell contents limits, etc.

[1900b]

Thanks guys for the info I think I'll have a look at 2007 for now. I already noticed that importing Betfair's historical data is only possible in 2007 because of the size of the data files. Through my work I have access to both versions, so I don't have to buy a version. The sharing of files is a point to keep in mind, however before I get to that point a newer version of excel is probably available. I work on a mac so Paralel Desktop is going in overtime mode...