Save As Problem

Hi, I have a macro that brings up a dialog box asking the user what they would like to name the file:

Please Login or Register  to view this content.

I have previously directed things to a specific folder like this:

Please Login or Register  to view this content.

What I want to do now is have a second input box for the user to select the folder at the end of a specific path. What I tried was:

Please Login or Register  to view this content.

I have it wrong somewhere but I can't figure out where. Can anyone suggest a way of doing this? (the folders will always be in W:\Planning)

Thanks,

Dean

Dean,

First, be sure to go back to your post #1 above and add CODE tags around your posted code, as per forum rules. We don't want your thread to get moderated, ok? Like mohd showed in their post above, and demonstrated in my signature below.

Once you have a "method" that seems to be getting you close, try a forum/Google search on the main keywords to see what other "parameters" might be available, or to just view other examples of the method. IN this case, the keyword search would be for FileDialog(msoFileDialogSaveAs)...

This is one of the additional parameters you can add:

Please Login or Register  to view this content.

You could even go further and have it fill in a suggested filename:

Please Login or Register  to view this content.