View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] aidan.heritage@virgin.net is offline
external usenet poster
 
Posts: 244
Default Saveas with date problem

You are using slashes in your file name, which isn't allowed - they
indicate a new directory - so try

"mainfile-" & format(date,"dd-mm-yyyy")

should do it for you!