Creating macro on how to save file within Excel file
David,
I haven't tried it in a macro, but I don't think it's necessary to append
".csv" onto the file name. The CSV file type specified will cause Excel to
do that (as long as the given file name does not end with a period).
Just thought I'd mention it.
Regards from {*filter*}ia Beach,
EarlK
-------------------------------------------------------------
Quote:
> Try this
> Sub SaveAsCSV()
> Dim Temp
> Temp = Format(Date, "mmm-dd-yyyy")
> Temp = "L:\ABC\" & Temp & ".csv"
> ChDir "L:\ABC"
> ActiveWorkbook.SaveAs Filename:=Temp, FileFormat:=xlCSV, _
> CreateBackup:=False
> End Sub
> You may wish to change date format
> >Hi Everyone,
> >I need some help on how to create macro to save file
> >(specifically on .csv extension) on specific destination
> >(LAN drive) with the filename uses the system date, like
> >for example: L:\abc\January2003XXXX.csv. How do I do
> >this? can anybody help me on this please?
> >Thanks in advance for your help.
> >Regards
> >Eric
> Anti Spam Signature - replace .net with .com
