file Save As issue

Originally Posted by Norie

Ray

Try explicitly specifying th file format when saving.

  ActiveWorkbook.SaveAs Filename:="\\Omaw2kfile02\CompanyPublic\Cust_Serv\MASTII\Company\Test\Input\CompanyConvert" & ".xls", FileFormat:=xlExcel8.

This worked great Norie, Thank you for the quick response

Ray