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

"Ayo" wrote:

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

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

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

"Ayo" wrote:

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

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