VBA – MS Learing Site (Office 03′ Win 2K Pro)

Topic

New Reply

Does anyone have expereince with the free Microsoft VBA Development and training centers/sites??

Reply | Quote

Replies

What site is it??

I recently watched some archived webcasts on ASP.NET development as compared with PHP development, or to integrate with PHP. After watching 3 webcasts, MS sent me a free copy of Visual Studio 2005 Standard Edition. I can’t say I really retained much of what I watched, but I certainly appreciated the inducement.

Reply | Quote

(Edited by HansV to make URLs clickable – see Help 19)

The first is the general MS Learning site and the second is the assessment site for Visual Studio, Office etc.all the MS products.

http://www.microsoft.com/learning/default.mspx%5B/url%5D, http://assessment.learning.microsoft.com/test/home.asp%5B/url%5D

Reply | Quote

Not entirely free but Microsoft Step by Step books were written for both Access VBA and Excel VBA. I don’t think they were updated for the 2003 Version, but from the 97 – 2002 Verions of the books there were very few changes made. At places like ebay and some of the used or older book web sites I have seen these books sometimes sold for as low as $5-$10. I have also seen them go for as much as $80 as they are now out of print and were excellent. You would definitly have to do some shopping to get a good price. I used both books as training material for classes I taught on this subject matter and thought both of them to be excellent well thought out material. I have seen the code from the Access VBA book in many databases I have worked with taken literally from the Access book.

It might be worth a look if you are willing to shop and make a small investment.

Carla

Reply | Quote

Carla,

I found and purchased “Word 97 Macro & VBA Handbook” by Guy Hart-Davis on Amazon; hopefully this is a good choice. Thanks for the input…

Marty

Reply | Quote

Just as a footnote, there were some excellent additions to VBA starting in Office 2000. These included the invaluable Split() method. If you find that your book does not cover all of the methods you find in sample code, you could consider a “nutshell” reference book, such as the following:

oreilly.com — Online Catalog: VB & VBA in a Nutshell: The Language

In that 1998 book, the newer language features marked (VB6) are the ones that appeared in Office 2000.

Reply | Quote

THat is not an Office VBA book, tho it is a useful reference.

Reply | Quote

That book is quite outdated and weak in content. Not at all useful for reference.

Best to start with Steve Roman’s Writing Word Macros and, if you can find one, The MSFT Press Step by Step book for Word VBA.

Reply | Quote

See the list of books at http://www.standards.com/index.html?WordVBABooks%5B/url%5D.

Reply | Quote