file Save As issue

Hi, rdowney79,

maybe like this (but I donīt favour this approach if I canīt control how mayn othe rworkbooks are open):

  With Application
    .DisplayAlerts = False
    ActiveWorkbook.SaveAs Filename:="\\Omaw2kfile02\LozierPublic\Cust_Serv\MASTII\Walgreens\Test\Input\WalgreensiSupplier" & ".xls", _
            Password:="", WriteResPassword:="", _
            ReadOnlyRecommended:=False, _
            CreateBackup:=False, _
            FileFormat:=56
    .DisplayAlerts = True
    .Quit
  End With

Ciao,
Holger