View Single Post
 
Old 11-01-2013, 09:43 AM
terraterm terraterm is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Nov 2013
Posts: 4
terraterm is on a distinguished road
Unhappy Word Macro saving with different filename

i need help

i don't know anything about writing scripts.

what i'm trying to do is as follows:

"copy text from anywhere"

paste the text into word, save the file with a different filename everytime, in the same directory, close the file, open a new blank file

the Macro i recorded as follows.

1: ctrl +v
2: F12
3: ctrl +w
4: ctrl +n

It works the first time, the SaveAs dialog box pops up, paste the proper filename, close, open new.

Running it the second time around it justs overwrites the contents of the file, and saves it with the previous filename used.

Since I'm asking for a SaveAS, should it not prompt me for a filename?

How do I get the SaveAs Dialog box everytime, or have the macro grab the last entry from the clipboard, and use that as a filename?
Reply With Quote