george hart
Board Regular
- Joined
- Dec 4, 2008
- Messages
- 241
Hi
Can anyone advise how I can change the code below to ensure that only a specific "worksheet" is saved with a specific file name absence - and "todays" date in the same location of the initial file?
In short - save as (same location) absence-11-03-11
Dim NewFileName As Variant
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
NewFileName = Application.GetSaveAsFilename("Absence-", "Excel Files (*.xls), *.xls", , "Save Daily Report")
<o></o>
<o></o>
ActiveWorkbook.SaveAs Filename:=NewFileName
Thanks in advance
<o></o>
Can anyone advise how I can change the code below to ensure that only a specific "worksheet" is saved with a specific file name absence - and "todays" date in the same location of the initial file?
In short - save as (same location) absence-11-03-11
Dim NewFileName As Variant
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>NewFileName = Application.GetSaveAsFilename("Absence-", "Excel Files (*.xls), *.xls", , "Save Daily Report")
<o
></o><o
></o> ActiveWorkbook.SaveAs Filename:=NewFileName
Thanks in advance
<o
></o>
