Thread: Save as
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Edgar[_3_] Edgar[_3_] is offline
external usenet poster
 
Posts: 40
Default 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")