View Single Post
 
Old 12-14-2007, 08:14 AM
mikeburg mikeburg is offline
Novice
 
Join Date: Jun 2006
Posts: 2
mikeburg
Default Put File Name Of A Document On Line 1 Of The Document

I am needing auto open VBA code that will center the name "FAX MESSAGE COVER PAGE", the document's file name (always different) & today's date all on line 1 when it's opened (I already have auto open VBA that save the document, with Save As, the user's name in the file name).
For example, when I open the document MW070.doc, it's auto open VBA has saved as MW070mike.doc. What I need is the following centered on the 1st line:
FAX MESSAGE COVER PAGE MW070mike.doc 12-14-07
Keep in mind, the MW070mike.doc, will be MW070sherry.doc if user sherry opens MW070.doc, etc. So the VBA needs to use the new file name in the Line 1 line.
Thanks so very much for all your help. mikeburg
Reply With Quote