Only save selected sheets in new file?

[jamewoong]

Hi,

Is there a way to only select some specific sheets in a workbook and save them in one single file (save as)?

Client List.xls

Summary:
I create a macro that will do a save as with the current date... (Save Button in the Total Loss tab).

What I want is when clicking on it, it will make a copy of the tab "Total Loss, Company 1, Company 2, Company 3" and will save *** a new file containing only those 4 tabs.

Is that possible?

Thanks

[HaHoBe]

Hi, jamewoong,

maybe like this:

Please Login or Register  to view this content.

Please mind that you will get a message from VBA if you run the same routine more than once on a given day asthe workbook does already exist. You would need to give details if you replace it (use Application.DisplayAlerts = False before saving and turn the event on after doing so by Application.DisplayAlerts = True). If you need all of the copies please come back for more information on how to add a running numbe for that day. For my part I would prefer to have the date in the way of Year first, Month as Day following.

Ciao,
Holger

[jamewoong]

Thank you HaHaBe!

I would like to know if there is a way to change the code to save it as the current Date + custom filename
>>> 06-Nov-2013 Total Loss.xls

Do you know how?

Thanks again.

[HaHoBe]

Hi, jamewoong,

current Date + custom filename

What is custom filename? A constant? Where shall this be defined?

Please Login or Register  to view this content.

Ciao,
Holger