Save As Dialoq Box

[backfromthebush]

Hi all,

This is probably really really easy but I just can't work it out!

I want to put a line in my code that will bring up the "Save As" dialog box, so the user can choose where to save the file and what file name to give it. When it saves it will continue onto the next step in the code.

Any help???

 

[Greg Truby]

Here's how you figure this stuff out on you own. :wink:

In the VBE, hit the F2 key to open the Object Browser.In the Search box, type in "SaveAs".

You'll see a number of results there. Which one looks the most promising to you?

Yup - the GetSaveAsFilename method of the Application object looks pretty promising to me as well. So click on that one and hit F1 and check it out in VBE help.