Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File SaveAs
I have a text file that I have imported and done some formatting on. Now I
want to use VB to automatically save the file as an .xls to the current path with the current date. For example, the text file may be named MyTextFile.txt, so I want to save it to current path/MyTextFile_Today's Date_Review.xls. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File SaveAs
FinChase
ActiveWorkbook.SaveAs "MyTextFile_" & Format(Date,"yyyymmdd") & "_Review.xls" -- Dick Kusleika MVP-Excel www.dailydoseofexcel.com FinChase wrote: I have a text file that I have imported and done some formatting on. Now I want to use VB to automatically save the file as an .xls to the current path with the current date. For example, the text file may be named MyTextFile.txt, so I want to save it to current path/MyTextFile_Today's Date_Review.xls. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Confused here Prevent Saving File - but allow ONLY File SAVEAS Met | Excel Discussion (Misc queries) | |||
saveas CSV file | Excel Discussion (Misc queries) | |||
Saveas where file already exists | Excel Programming | |||
VBA-Excel. File-SaveAs | Excel Programming | |||
Saveas with name of another file | Excel Programming |