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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding outlook mail Subject Line to saved attachment 0
Outlook macro for specific email 0
Date problem 1
Date custom formats 2
Saving email attachments 6
Formatting Dates from Text to Numbers 2
Simplify save code 11
Date Posting 1

Back
Top