ExcelBanter - Save As Error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Save As Error (https://www.excelbanter.com/excel-discussion-misc-queries/181021-save-error.html)

Ayo

Save As Error

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

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

Mike H

Save As Error

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?

Mike H

Save As Error

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?

All times are GMT +1. The time now is 01:36 PM.