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
|