View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default VBA 2003 and XP compatible?

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

"Joel" wrote:

Not all VBA functions are available in Excel VBA.

"OssieMac" wrote:

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

Regards,

OssieMac

"iamito" wrote:

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