Avoid Auto Republish Error Help!

[mkp007]

I have an Excel VBA program that saves the Excel file every 5-10min. It also publishes a web page with selected ranges of cells. This works 98% of the time. Today I got an error that stopped my program and required me to click ok on the error box. It said "ERROR: Cannot access file in Excel publish to webpage setup" and it indicated the file was the "summary.htm" which is the web page file that I write to. The file is local on my computer so it is not a server access problem.

Is there an outside chance that my saves are too close together?? I would think that the VBA would wait until the saving is complete before it continues.

Should I check the webpage file "summary.htm" for write access before I save the Excel file?

Does anyone have a recommendation?

This person has a similar problem: microsoft - ERROR: Cannot access file in Excel publish to webpage setup - Stack Overflow

 

[mkp007]

Note, this error did not cause the normal VBA error box to show up. For one, I suppress/capture vba errors. This error came from Excel and the error box it displayed was one I had not seen before. I should have taken a screen capture of it but didn't think of it until after I dismissed it by clicking "ok". The VBA quickly started back where it had left off.

Again, any thoughts would be appreciated.

 

[mkp007]

I think this example will work Confirm File Has Read/Write Access

I just need to try it with an html file.