Thread: Type mismatch
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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.

.