B
brotherescott
I have a macro that opens up a word doc using a template. I rename the
current "Document 1" that it automatically gets named with something
like "2006.09.08 Phone Conv. ". I want this text to always be there so
I just add in somthing unique at the end when I do a save as to a
location that I want to put it. Here is where my problem comes in. When
I do the ActiveDocument.SaveAs to give it this starter file name it
actually saves a copy in what ever directory is current. When I do a
saves as and give it the final name in the directory I want it to be in
it saves fine but I go back to where ever the current path was when the
VBA code did the ActiveDocument.SaveAs and I see a copy there of the
original document.
Basically, how can I rename the active document with out saving it?
ActiveDocument.Name="test.doc" does not work.
Documents.Add Template:= _
"C:\Templates\Phone Conversation.dot" _
, NewTemplate:=False, DocumentType:=0
ActiveDocument.SaveAs FileName:=Format(Now(), "yyyy.mm.dd") & " Phone
Conv- "
Thanks
Scott
current "Document 1" that it automatically gets named with something
like "2006.09.08 Phone Conv. ". I want this text to always be there so
I just add in somthing unique at the end when I do a save as to a
location that I want to put it. Here is where my problem comes in. When
I do the ActiveDocument.SaveAs to give it this starter file name it
actually saves a copy in what ever directory is current. When I do a
saves as and give it the final name in the directory I want it to be in
it saves fine but I go back to where ever the current path was when the
VBA code did the ActiveDocument.SaveAs and I see a copy there of the
original document.
Basically, how can I rename the active document with out saving it?
ActiveDocument.Name="test.doc" does not work.
Documents.Add Template:= _
"C:\Templates\Phone Conversation.dot" _
, NewTemplate:=False, DocumentType:=0
ActiveDocument.SaveAs FileName:=Format(Now(), "yyyy.mm.dd") & " Phone
Conv- "
Thanks
Scott