Need to Overwrite existing XML file - Error 58

[VBABegin]

Hello,

I keep getting a runtime error 58 when it comes to overwriting an existing XML file. It gives me the error and I don't get the option to overwrite it. I'd rather that it not ask me and just overwrite the file. The code is below.

Please Login or Register  to view this content.

[Kevin#]

Looking further up your code, each file name would be unique
if this line was replaced

Please Login or Register  to view this content.

WITH

Please Login or Register  to view this content.

I am suggesting this because of these lines:
Filepath = "V:\9 O'Clock Meeting\billboard\"
Filename = "billboard" & " " & Format(Now)
File = Filepath & Filename & ".xml"

So I would expect the full path to be "V:\9 O'Clock Meeting\billboard\billboard" & " " & Format(Now).xml"
(which would be unique)


EDIT - afterthought
You may have a problem saving a file with Format(Now) because of the slashes - is this why you abandoned it?

Use something like Format(Now, "DDMMYY") instead

[Kevin#]

If you want to keep using the same file name repeatedly, another option would be to delete the file before creating it again.

(using your original path) something like

Please Login or Register  to view this content.