View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] lisamariechemistry@yahoo.com is offline
external usenet poster
 
Posts: 24
Default Suppress error message with saveas

In one particular section of my module, I'd like to perform a
workbook.saveas that will:

1.) suppress the "file already exists" error message (I can do that
with OnError..) 2.) always go ahead and save over the existing file
(how?)

(I saw someone had asked about a related situation, using On Error
GoTo 0 to move on to the next task instead of overwriting the existing
file...close but doesn't quite get me there) Help?