Visual Basic for Apps online tutorial

[Doug Waters 03/03/08]

Can anyone tell me where to find a REAL Visual Basic for Apps online
tutorial? Everything I'm finding just has links pointing you back and forth
from one webpage to another but not actually showing any source code.

Also, the VBA I have is version 6.5.1024, which comes up from the Macro
menus in my Office Professional Edition 2003 version 11.0.8173.0. Does it
have all the libraries needed to support whatever source code I find? When I
try to run the following macro

Sub AboutVB1()
Selection.TypeText Text:="Hello World!"
End Sub

I get Run-time error 424 (object required). (I probably just need to make
the appropriate declaration, but without the tutorial, I don't know how to do
that.)

Thanks for any help anyone can give me.

 

[Doug Robbins - Word MVP]

Use

Selection.Text = "Hello World"

See the article "Getting To Grips With VBA Basics In 15 Minutes" at:

http://www.word.mvps.org/FAQs/MacrosVBA/VBABasicsIn15Mins.htm

and other articles on that website.




--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP