[RESOLVED] oXLBook.SaveAs FILENAME options/flags?

[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

[Siddharth Rout]

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?

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

[shadderk]

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