SaveFileAs
 

Hey everyone,

I've learned quite a bit within the last few weeks, but you'll have t
bear with me with this question and explain it as simple as possible.
I have a single template excel document that I will eventually hav
numerous "copies" of. What I want a macro to do is thus: ask the use
what they want the new document's name to be, simply open up th
standard document, save it to what the user specified, then close."
There are a few other things i need to do, but I can work around wha
you can hopefully provide. Thanks!

Dee

--
Message posted from http://www.ExcelForum.com

SaveFileAs
 

Deej,

There is a GetSaveAsFileName method which allows you to select a directory,
and select or enter a filename, and it will return the full path and file
name in a variable which you can then use to save the file with.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"cogito " wrote in message
...
Hey everyone,

I've learned quite a bit within the last few weeks, but you'll have to
bear with me with this question and explain it as simple as possible.
I have a single template excel document that I will eventually have
numerous "copies" of. What I want a macro to do is thus: ask the user
what they want the new document's name to be, simply open up the
standard document, save it to what the user specified, then close."
There are a few other things i need to do, but I can work around what
you can hopefully provide. Thanks!

Deej


---
Message posted from http://www.ExcelForum.com/