Macro in Word 1

[dk99]

I have a macro in word and when it finished it automatically saves the file for me, but I want it to prompt me for the file name before it saves.

How can i do this ?

 

[dyarwood]

Use an input box

something like

filenam = InputBox(Prompt:="Enter filename&quot

then use the string filenam in the save command

dyarwood

 

[dk99]

thanx this works but can I get it to input just part of the file name.

For example the prompt would only ask for the date and then it would save it as:

date_newfile.doc

_newfile.doc is always the same only the date changes ?

 

[dyarwood]

Use the input box as above but then do the following

filenam = filenam & "_newfile.doc"

This will give the file name I would think you need

Is the date you want the present date?

If so you could try using the NOW() function.

dyarwood

 

[dk99]

Perfect - THANKYOU !

 

[dyarwood]

Not a problem, cheers for the star

dyarwood