Naming exported file

Hello, i´ve got this code to save worksheet2 as new excel file. Is it possible to automatically name that exported file from value in choosen cell?

For example if A1="Henry´s list" then file name will be named "Henry´s list". Thanks for answer.

Please Login or Register  to view this content.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

Please Login or Register  to view this content.

... and appear like this when posted:



copy to clipboard
your code here ...
and here ...
and here
You can also type the code tags in manually if you prefer. For more information about these and other tags, click here.

Yes, thank you.

Please Login or Register  to view this content.

Just pass the cell value into the 'GetSaveAsFilename' call.