Copy a sheet, rename it by value in range then export product to new workbook and rename

Hi Guys,

I have a workbook that, thanks to the enormous help on here, does all kinds of wonderful things.

To finish it off, what I'd like to do is this

Copy the tab called "User to System Matrix" but have all the contents saved as values
Rename the new tab by the value in cell C2 of the "Welcome" tab

Export the new tab into a new workbook and save it with the filename of today ("yyyymmdd - Tabname")
Save the original workbook with the filename of "yyyymmdd - <value in cell C2 of the "Welcome" tab> - MASTER

Sorry, on both the Saves, can it put the filename but not actually save but allow the user to navigate to where they wish to save the files

Thanks guys

Terry

This Code will do all of the exporting etc but not save the files

Please Login or Register  to view this content.

This is the Save As command you can use to help you..
It is possible to automatically save to a folder using a path but I am unsure if you can leave the dialog box open!
https://msdn.microsoft.com/en-us/lib.../ff195820.aspx

user to navigate to where they wish to save the files

Try adding the command

Please Login or Register  to view this content.

at the end at the code.

If e is the string that contains the new file name include it in the "Application" as

Please Login or Register  to view this content.

Alf