Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / November 2004

Tip: Looking for answers? Try searching our database.

Save As Macro with File Name

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sally t - 18 Oct 2004 12:09 GMT
Is it possible to write a Save As Macro that I can run on exit from a form
field tht will prompt the user to Save As and also put in a filename
(standard filename that they can then amend).  Let them save then continue
going through the form fields? Many many thanks. Sally T
Chris - 18 Oct 2004 15:11 GMT
Hi Sally

I "borrowed" most of this out of the Visual Basic Editor Help File, but did
a little editing to simplify it (it was from 2 seperate examples).  I presume
this will slip into another macro if you're trying to prompt the user to do
the save after entering information into a field.  You'll need to save it as
a piece of code and call it as a separate macro, or copy the 4 lines of the
macro into the correct spot of the other macro.

Sub SaveAsTextFileMacro()

strDocName = InputBox("Please enter the name " & _
           "of your document.")
ActiveDocument.SaveAs FileName:=strDocName, _
       FileFormat:=wdFormatDocument
End Sub

Is this what you were looking for?

Cheers

Chris

> Is it possible to write a Save As Macro that I can run on exit from a form
> field tht will prompt the user to Save As and also put in a filename
> (standard filename that they can then amend).  Let them save then continue
> going through the form fields? Many many thanks. Sally T
sally t - 31 Oct 2004 21:45 GMT
Help! I don't really know what I'm doing Chris but I tried using Macro -
Create and typing those instructions but nothing happens if I then try to use
Tools - Macro - select it and Run.  What is the exact process for creating
such a macro to prompt File - Save As -I'm probably missing something vital
out, not being a VB person at all!  Thanks

Sally

> Hi Sally
>
[quoted text clipped - 23 lines]
> > (standard filename that they can then amend).  Let them save then continue
> > going through the form fields? Many many thanks. Sally T
Doug Robbins - 01 Nov 2004 01:04 GMT
See the article "What do I do with macros sent to me by other newsgroup
readers

to help me out?" at:

http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Help! I don't really know what I'm doing Chris but I tried using Macro -
> Create and typing those instructions but nothing happens if I then try to
[quoted text clipped - 40 lines]
>> > continue
>> > going through the form fields? Many many thanks. Sally T
sally t - 04 Nov 2004 21:59 GMT
Thank you all for helping me on this.  Much appreciated.

Sally

> See the article "What do I do with macros sent to me by other newsgroup
> readers
[quoted text clipped - 47 lines]
> >> > continue
> >> > going through the form fields? Many many thanks. Sally T
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.