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







      set XLApp = Nothing

      set XLDOC = Nothing

      set XLSheet = Nothing





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