Word VBA-Autoexec macro

Using NT 4.0 and Office 97.  Tried to develop a macro as outlined in an excellent book.  Used the VBEditor, input the lines of code and it was supposed to ask who I am when I restarted Word.  Obviously, didn't happen.  Made the update to the Normal.dot.  What am I missing?  Thank you for helping me learn this.  
BegnrSteveAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BegnrSteveAuthor Commented:
Edited text of question.
0
blakeh1Commented:
was the macro placed in the Normal.dots open event or is it called auto_open?
0
NickRackhamCommented:
Is this loaded as a global template?

Use the AutoNew to ensure it runs when ever you open a new doc.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

BegnrSteveAuthor Commented:
Well, I am more lost now than I was.  Here is the code I was to input in the Normal.dot as the global template each time Word 97 executes.

Public CurrentUser As String
Sub AutoExec()
  CurrentUser=InputBox("Please enter  your name.", "Current User Identity")

End Sub

Sub Identify_Current_User()
  MsgBox "The current user is " + CurrentUser, vbOKOnly + vbInformation, "Current User"

End Sub

I put the Public Current User in the General Declarations area and, of course, the subroutines separated out as I started each routine.  The author of the book directs me to save and then close Word8.0 and then reopen Word.  These macros should run upon opening a blank document.  

How do I set the Auto_Open property on the Normal.dot?  I like that idea.  And, how do I access and update the AutoNew?  I like that idea, too.  Thank you for responding to my lack of knowledge.

v/r
BegnrSteve
0
NickRackhamCommented:
create a new macro called AutoNew then copy your code into the new macro. Save it in Normal.Dot.

It should now run when a new doc is created.

Nick
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BegnrSteveAuthor Commented:
Thanks.  This will definitely work.  You deserve more points than I proposed.  Have a Happy New Year!
0
NickRackhamCommented:
No Problem, Getting points is rewarding but so is "Thanks"

Happy New Year to you too.

Nick
0
BegnrSteveAuthor Commented:
Nick,

Got back to work today from the dear old flu--tried your suggestion and it worked as advertised.  Thanks, again.

Steve
0
NickRackhamCommented:
No problem, Hope you're feeling better?

Nick
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.