ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA 2003 and XP compatible? (https://www.excelbanter.com/excel-programming/396161-vba-2003-xp-compatible.html)

iamito

VBA 2003 and XP compatible?
 
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


OssieMac

VBA 2003 and XP compatible?
 
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



joel

VBA 2003 and XP compatible?
 
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



Alok[_3_]

VBA 2003 and XP compatible?
 
On Aug 23, 3:25 am, 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


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.


OssieMac

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




All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com