Quick VBA query

[selenay]

There are several programmers on my f-list, so I figured that someone might have some ideas. Does anyone know where I can find a decent VBA technical reference on-line? My company doesn't supply technical manuals (hmmph!) and I'm have trouble hunting down some of the things that I need to do. We're running Office 97 at the moment although hopefully we'll be updating to 2003 soon :-) Any help would be much appreciated.

Comments

[paranoidangel]

I have the following on my favourites list here at work, so they must have been useful at some point:

http://www.excel-vba.com/av-contents.htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovroffice2000visualbasicprogrammersguide.asp

http://www.vba-programmer.com/

http://www.mrexcel.com/

Although I use the last one the most - their forum is quite helpful, once you manage to find anything!

When I wanted to learn VBA for work, I went and read a load of books in Borders, then bought myself one off Amazon. The advantage is that I now have a book, plus I can also take it with me when I leave.

[selenay]

Thanks! The third link on your list was particularly helpful - I even found a snippet that did exactly what I needed this morning to overcome an unexpected technical hitch :-)

I learnt the basics of VBA on a training course through work, but don't have any technical manuals or placed to look when I need to find some of the more advanced functions. These references have been bookmarked and will be well used :-)

[gmul.livejournal.com]

Not directly related but

http://www.w3schools.com/vbscript/vbscript_ref_functions.asp

can be handy if you need a second opinion.

And they have http://www.w3schools.com/downloadwww.htm which is good for a quick giggle.

[selenay]

Thanks :-) Loving this language....not *snort* I need all the giggles that I can get....

[paranoidangel]

I do like your icon :)