How to execute macro requiring an entry on the "save as" menu

Hi there,

Here is what I need to do; I have a macro that formats the presentation of a sheet, saves a PDF, then restores the original formating.

However, the user need to be able to use the "save as" menu in order to select new save location and the default title is contained in a cell. Once the user pressed ok, macro must resume to proceed with format and update screen.

So, is it possible to program the appearance of the "save as" menu with the content of a cell as a file name, then ensure the macro goes on when the user presses ok in this menu?

Thanx.

It answers only part of what I needed; the user still needs to be able to specify the save path.

However, you did tell me how to use the content of a cell for the filename; it works great! So, anyone about activating the save as menu?

If I do invoque the interface with

Please Login or Register  to view this content.

I do have 2 questions:

- How can I make the file type PDF as default?
- Can I compose the .show argument with two cells? For instance, I could used the hard coding tip given by RoyUK like this:

Please Login or Register  to view this content.

can I do something similar? I tried, and could not get it done...

While it seemed promising, this doesn't do it.

Please Login or Register  to view this content.

Does nothing unless I use only values like this:

Please Login or Register  to view this content.

Then, the file name appears correctly (but I still would like to add a point to separate!). And then again, I am stuck with being unable to make the PDF file type as default.

I guess the right answer lies in between all of this, but still could not figure it out! Anyone?