SaveAs Excel

[daveStudent]

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

[Pirate]

Try something like this :

Dim sv As New SaveFileDialog
sv.OverwritePrompt = False

[daveStudent]

Pirate,

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

regards

db

[Pirate]

Sorry , got no clue about this .

[<ABX]

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

xl.Workbooks(1).Save

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

[daveStudent]

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

[Pirate]

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 .

File.Delete(path)

[Pirate]

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

Imports System.IO

[daveStudent]

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