VBA 2003 and XP compatible?

[iamito]

Hi

I have to start learning VBA. At work I'll be using Office XP, so I'd
like to know if VBA for Excel 2003 is the same as VBA for Excel XP.

I'm asking this because I already have a book for VBA 2003 but not for
VBA XP.

Thanks for the help.

Miguel

 

[Guest]

There is little if any difference and I doubt that you will come across
anything that will cause you any distress.

Regards,

OssieMac

 

[Guest]

Not all VBA functions are available in Excel VBA.

 

[Alok]

Hi

I have to start learning VBA. At work I'll be using Office XP, so I'd
like to know if VBA for Excel 2003 is the same as VBA for Excel XP.

I'm asking this because I already have a book for VBA 2003 but not for
VBA XP.

Thanks for the help.

Miguel

You do not need a separate book. AFAIK, the VBA version is exactly
same. The Excel version difference may lead to very slight difference
in the object model but that is something you need not worry about
till much later.

 

[Guest]

Hi Joel,

I don't really get what you mean by your statement? They are both Excel VBA.

Iamito's question was 'if VBA for Excel 2003 is the same as VBA for Excel XP'

I think that my answer of 'little if any difference' is fairly accurate. I
am not saying there is no difference but I have Excel XP (also known as
xl2002) on one of my computers and over the past few years I have had 3 books
from my local library on VBA for xl2003 and I haven't come across anything
which didn't work with Excel XP.

Having said that here is a tip for Iamito: The help for VBA is not the same
help as you use when on the worksheet.

I have known of a number of people who have had the Help open on the
worksheet and when they want help in the VBA editor they switch windows to
the help they already have open and of course they cannot find what they want.

If you want Help in the VBA editor then you need to open it while in the VBA
editor so that you are looking at the correct one. Also it does not keep 2
help windows open. The one for the worksheet closes and the VBA one opens.

Regards,

OssieMac