Save as
What is wrong with the following line of code?
I would like it to save a copy of the current workbook to
the directory listed with the name as todays date
formatted dd-mmm-yy
TIA
ActiveWorkbook.saveas ("C:\Documents and Settings\ThoemmE1
\Desktop\Shares\Web Query Data\UK Shares by Sector\" &
Format(Date, dd-mmm-yy) & ".xls")
|