[RESOLVED] oXLBook.SaveAs FILENAME options/flags?

I am wondering if there are any flags that I can set on this command so that it saves the file, and will not prompt the user if a file of the same name already exists.

I opened up a template file and added to some of the fields, then wasnted to save as a new file (filename), however that (filename) may already exist, if it does I dont want the application to prompt the user for anything, I want to always overwrite any existing files.

Derek

Quote:

---

Originally Posted by shadderk

I am wondering if there are any flags that I can set on this command so that it saves the file, and will not prompt the user if a file of the same name already exists.

I opened up a template file and added to some of the fields, then wasnted to save as a new file (filename), however that (filename) may already exist, if it does I dont want the application to prompt the user for anything, I want to always overwrite any existing files.

Derek

---

Does this help?

vb Code:

Sub SaveAsFile()
 
'Disable dialog Box
Application.DisplayAlerts = False
        
'Your Code
'oXLBook.SaveAs FILENAME.... blah... blah...
 
'Re-enable Dialog Box
Application.DisplayAlerts = True
 
End Sub

Yahoo!!

That was exactly what I was looking for. Took care of the issue I was trying to solve.

What a great start to a monday morning..

Thank you for the help there.

Derek