VBA Language Reference


Posted by Michele on September 03, 2001 7:59 AM

Can anyone tell me where I can get documentation on VBA - User Reference Guide or whatever which would tell me what the language is, e.g. ActiveWorkbook.FullName gives the Path Name of the Active Workbook, etc., etc., etc.
Many thanks,
Michele

Posted by steve w on September 03, 2001 9:37 AM

Not sure what you want?
a book maybe?

VBa is a modified version of visual basic 6, that is used in some of microsofts programs.
Its simply a programing language and I feel that its a pretty user friendly.
Let me know if you need some kind of help in understanding it and I'll do what I can

steve w

Posted by Michele on September 04, 2001 4:24 AM

Thanks Steve. Perhaps it's a book but I was hoping something would be available on the web.
What I need is a list of all the "instructions" available and what they do, e.g.,
Range("celladdress").Value - returns the content of the cell addressed.
ActiveWorkbook.FullName - returns the full path & file name of the active workbook.
I don't need to know how to program - I've been doing this since 1959. I just need to know what the language is.
By the way, I'm Canadian and don't have a problem with English or French but I'm presently living in Vienna, Austria and that means the German language - more difficult than all the computer languages put together! We have a very limited English book store which doesn't make book shopping very easy. So if it's a book I need, I would appreciate some recommendations.
Thanks for you interest & help.
Michele



Posted by Dax on September 04, 2001 8:26 AM

If you want a good book which describes the complete Excel object model and the VBE/VBA object model then have a look at Excel 2000 VBA by John Green published by Wrox press. It is aimed at the more advanced user and includes some more advanced topics such as programming the VB Editor (rather than Excel) and using API calls to do stuff that you can't do with VBA.

Also, the online help is fairly invaluable and the object browser is an very useful to see exactly what methods, properties and events are associated with which object, although it may be confusing initially.

Regards,
Dax.