Save As Macro with File Name

Tutorials Win: Microsoft Windows Forum

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
Top

RE: Save As Macro with File Name by Chris

Chris
Mon Oct 18 09:11:08 CDT 2004

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

"sally t" wrote:

> 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
Top

RE: Save As Macro with File Name by sallyt

sallyt
Sun Oct 31 14:45:02 CST 2004

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

"Chris" wrote:

> 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
>
> "sally t" wrote:
>
> > 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
Top

Re: Save As Macro with File Name by Doug

Doug
Sun Oct 31 18:04:50 CST 2004

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


--
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
"sally t" <sallyt@discussions.microsoft.com> wrote in message
news:29FDBF32-33D9-4E93-8FC9-04A64EA299E5@microsoft.com...
> 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
>
> "Chris" wrote:
>
>> 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
>>
>> "sally t" wrote:
>>
>> > 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


Top

Re: Save As Macro with File Name by sallyt

sallyt
Thu Nov 04 14:59:11 CST 2004

Thank you all for helping me on this. Much appreciated.

Sally

"Doug Robbins" wrote:

> 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
>
>
> --
> 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
> "sally t" <sallyt@discussions.microsoft.com> wrote in message
> news:29FDBF32-33D9-4E93-8FC9-04A64EA299E5@microsoft.com...
> > 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
> >
> > "Chris" wrote:
> >
> >> 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
> >>
> >> "sally t" wrote:
> >>
> >> > 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
>
>
>
Top