Amiga.org
The "Not Quite Amiga but still computer related category" => Alternative Operating Systems => Topic started by: AccyD on March 26, 2005, 08:46:28 PM
-
I just wondered if anyone knew of any good online tutorials for VBA for Excel (preferably free but cheap would be fine) that I can use to sort of kickstart my learning of the language. I've bought a book but it has rapidly become too elementary.
Any help would be greatly appreicated !!!
I know that most of you guys are going to slate me for wanting to use the "programming" language built into Excel but please dont - we all have different needs from a language and this one fits mine perfectly !!
-
VBA is a simple dialect of BASIC, just play with it for a few hours in the eveing, you'll soon pick it up... and don't forget that you can always use the in built help feature :-)
-
Like bloodline said, the Visual Basic language by itself is just another BASIC, but I gather you're more interested in the "for Applications" part of the abbreviation. The Microsoft Office and, more specifically, Microsoft Excel object models are well documented, and most sections of the documentation include sample code.
The "Microsoft Office Developer Center" should have all the information you need: . If you find yourself wanting more, I recommend reading up on .NET (if you're working with Office 2003) or COM (for all other versions).
Trev