Save As Error

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

objWkb.SaveAs saveFolder & "\DAILY WAR ROOM LOG_" & Format(DATE, "mmmm dd",
"yyyy") & ".xls"

I am getting a "Type Mismatch error", any ideas why?
 
Hi,


Assuming you have set objKkb and savefolder to something then this should work

objwkb.SaveAs saveFolder & "\DAILY WAR ROOM LOG_" & Format(Date, "mmmm dd
yyyy") & ".xls"

Mike
 
Hi,

Just and afterthought. I would be more usual to have the \ before the file
name as part of the save folder variable for example

saveFolder= "C:\thisfolder\thatfolder\
and omit it from in from of the filename text

Mike
 
Back
Top