Member Avatar for K.Vanlalliana
K.Vanlalliana 0 Light Poster

Whenenver I try to Save the Excel Workbook after editing the content by using this Code "xlwbook.Save", It always ask whether to replace the existing File or not. Is there any way to avoid this message? What shall I do to close the workbook silently (not seeing the Message).

I am using this to close my Excel File/Workbook:
xl.ActiveWorkbook.Close False, App.Path & "\EXCEL FILE\Book1.xls"
xl.Quit

But, the above code could not complete without seeing a warning message. Is there any other way, Please help.


KVL

  • 1 Contributor
  • 0 Replies
  • 50 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.