Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving .dot in template folder 1

Status
Not open for further replies.

gnt

Technical User
Aug 15, 2002
94
US
I'm a bit new to this vba stuff, so bear with me...

I am trying to save a Word template from vba into a specific folder. The template name is taken from an Access form, and I have no problem saving the template under that name. I just can't figure out how to designate the folder.
Here's a piece what I have - and where I'm assuming the code should go:
Code:
   Set docs = pappword.Documents
   docs.Add strWordTemplate

   With pappword
      .Visible = True
      .Activate
      .ActiveDocument.SaveAs strSaveName
   End With

Any help would be wonderful!
Thanks-
 
.ActiveDocument.SaveAs "C:\Myfolder\" &strSaveName
Regards
BrianB
** Let us know if you get something that works !
================================
 
Thanks Brain-
For some reason that wasn't working before, but is now. Maybe a typo.
Thanks for your help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top