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!

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!