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

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

Type mismatch
 

Thanks, but I broke the line simply for the purposes of
the post. In the module, it occupies one line.

Regards.

-----Original Message-----
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

.

Type mismatch
 

Are wb, SaveDir and fName all string variables?

If wb is a workbook object variable it will give a Type mismatch. In
that case, the call should be

wb.SaveAs ...

Otherwise, I can't tell from the info you've presented.

In article ,
wrote:

Thanks, but I broke the line simply for the purposes of
the post. In the module, it occupies one line.

Type mismatch
 

Many thanks.....you got it.

wb.SaveAs, since wb was an object variable.

Regards and thanks.

-----Original Message-----
Are wb, SaveDir and fName all string variables?

If wb is a workbook object variable it will give a Type
mismatch. In
that case, the call should be

wb.SaveAs ...

Otherwise, I can't tell from the info you've presented.

In article ,
wrote:

Thanks, but I broke the line simply for the purposes of
the post. In the module, it occupies one line.
.