Hi
I would like to have a code that would recongnized the name of the tab 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 tab 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 tab 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 tab 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
