Thread: Type mismatch
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_5_] Stuart[_5_] is offline
external usenet poster
 
Posts: 413
Default Type mismatch

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

Regards.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.588 / Virus Database: 372 - Release Date: 13/02/2004