Application.Dialogs(xlDialogSaveAs).Show

If this post helps click Yes
---------------
Jacob Skaria


"Allouette" wrote:

I am developing an Excel form for a very large group of inexperienced Excel
users at my workplace. The process needs to be as easy as possible! The
objective is for users to only have to input their unique data into the
master form and then click on a macro button. The macro generates a new
separate file with all their data processed in the manner necessary. That
all is working fine. However, each of these new files created through the
master form needs to have its own unique file name using a specific naming
convention. I would strongly prefer that the users not have to name their
new file themselves -- I want the macro to do it for them.

I can easily use formula to put the proper file name text into a cell of the
new workbook, but cannot figure out how to get it that text into the Save-as
file-name box when the file is first saved. This all would be very simple if
Excel worked like Word, where the default file name comes from the beginning
of the document. If I could just make it read A1 as the default that would
be great, but Excel defaults to "Book1" instead. Any suggestions would be
greatly appreciated!