Thread: Type mismatch
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Type mismatch

Try:

Workbooks(wb).SaveAs "C:\BofQProject\QSBofQ" & _
"\Projects\" & SaveDir & "\" & fName & ".xls"

(you can't break a string onto a new line using " _")

In article ,
"Stuart" wrote:

Dimmer than usual this evening.......what am I missing:

Workbooks(wb).SaveAs "C:\BofQProject\QSBofQ _
\Projects\" & SaveDir & "\" & fName & ".xls"

where wb = NewQSBofQ.xls
SaveDir = TEST 910
fName = DUPES