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!

FinChase

ActiveWorkbook.SaveAs "MyTextFile_" & Format(Date,"yyyymmdd") &
"_Review.xls"

--
**** 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!