SaveAs Excel

How do i SaveAs even if the file already exists.
I have this, but i still get the "Are you sure you want to overwrite..." from Excel

oWB.SaveAs("Filename.xls" , , , , , , Excel.XlSaveConflictResolution.xlLocalSessionChanges)

How do i use the saveAs method without needing to prompt the user?

thx

db

Try something like this :

VB Code:

Dim sv As New SaveFileDialog
sv.OverwritePrompt = False

Pirate,

I'm not using a Dialog, im using the SaveAs method of the workbook object.

regards

db

Sorry , got no clue about this .

do you want to save to the same file that you are working on?

VB Code:

xl.Workbooks(1).Save

If not just make a FileExist function and if the path exists delete it.

no, diff file name

maybe i can delete the old file then saveAs, this way i wouldnt have to worry about getting prompted about the overwrite.

I think an If statement seeing if the file exists, then delete if True would do the trick.

So yeah, how do i delete a file?

thx db

This is how to delete the file by passing the path & file name . I still don't get why you want to overwrite the file without promoting the user. I'm all Windows editions and all professional app behave this way . Give your user the choice and don't force him to do weird stuff . :D

VB Code:

File.Delete(path)

Opps , don't forget to include this at the very top of your form or a class where you'll use this function :

VB Code:

Imports System.IO

P,

I'm not prompting the user because this is a program that captures write speed to Network Drives.

Thanks for the IO stuff, it works fine now