Thread: Type mismatch
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.