Re: Saving File with macro
- From: "Die_Another_Day" <charles_suzyq@xxxxxxxxx>
- Date: 5 Sep 2006 14:30:49 -0700
Something like:
ActiveWorkbook.SaveAs Filename:="C:\YourPath\FILM " &
Format(Date(),"mm-dd-yy")
or more dynamic like:
ActiveWorkbook.SaveAs Filename:=ActiveWorkbook.Path & _
Application.PathSeparator & Left(ActiveWorkbook.Name, _
InStr(1,ActiveWorkbook.Name," ") - 1) & Format(Date(),"mm-dd-yy")
Charles
KelliInCali wrote:
I can't find the right code in any posts for this type of save. I just want
to save the current file to a specified location without specifying the
filename in the macro.
In the macro, the active file is a template that needs to be saved as a
spreadsheet. Ideally, I want to replace an existing file ("FILM 08-30-06")
using the current date in the format shown ("FILM 09-05-06").
tia -kelli
.
- Prev by Date: Autofill for checkboxes
- Next by Date: Re: Creating a custom formatting Macro
- Previous by thread: Autofill for checkboxes
- Next by thread: Re: Saving File with macro
- Index(es):
Relevant Pages
|
