2 Replies Latest reply: May 16, 2013 1:21 PM by Julio Lourenco RSS

    How to Save and Replace Excel File

    Nuno Ribeiro

      Hi ppl How can i save and replace a file ?

       

      My code

       

       

       

      Application.DisplayAlerts = False

       

      ...

       

      XLSheet.SaveAs"C:\TestXLS.xlsx"

       

       

      set XLApp = Nothing

      set XLDOC = Nothing

      set XLSheet = Nothing

       

       

      Application.DisplayAlerts=True

       

      when i try this wait..only open the edit module... when i remove application.DisplayAlerts...ask me if i want to replace the file :\