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