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

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

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

.

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.

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.
.