Hi
I would like to have a code that would recongnized the name of the Sheets that the user will select.
All the tabs are dates but the selection might be different from time to time.
I need to copy those tabs in a new folder and then save that new folder.
The new folder should be save with the name of the first sheet in the array.
see below for example.
Could someone help me with a VBA code. Thanks !!
Sheets(Array("2011-03-14", "2011-03-15", "2011-03-16", "2011-03-17", "2011-03-18")).Copy
ActiveWorkbook.SaveAs Filename:= _
"S:\Indem\06-CSI\02-Horaire\02A-Horaire unique CSI\Horaires Symposium 2011\Horaire du 2011-03-14.xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
ActiveWindow.Close
I would like to have a code that would recongnized the name of the Sheets that the user will select.
All the tabs are dates but the selection might be different from time to time.
I need to copy those tabs in a new folder and then save that new folder.
The new folder should be save with the name of the first sheet in the array.
see below for example.
Could someone help me with a VBA code. Thanks !!
Sheets(Array("2011-03-14", "2011-03-15", "2011-03-16", "2011-03-17", "2011-03-18")).Copy
ActiveWorkbook.SaveAs Filename:= _
"S:\Indem\06-CSI\02-Horaire\02A-Horaire unique CSI\Horaires Symposium 2011\Horaire du 2011-03-14.xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
ActiveWindow.Close
