Save file as - sheet names in workbook macro

[ian_a91]

Is it possible to get a file name to save is accordance with the names of the sheets inside the workbook?

For example I have 5 sheets in a workbook macro'd to date Monday to Friday e.g. 21/04/2014 - 25/04/2014

So I can have a macro that would save the file as "Weekly Summary - 21/04/2014 - 25/05/2014"

Any help would be much appreciated

 

[Joe4]

Sure you can build the file name like this:

MyFileName = "Weekly Summary - " & Sheets(1).Name & " - " & Sheets(5).Name & ".xlsx"

If you need to know what the "SaveAs" command in VBA looks like, you should be able to get that easy enough using the Macro Recorder.

 

[ian_a91]

Brilliant! Thanks so much Joe, this going to save me ton of time