publishing html using excel - problem with files becoming corrupt
 

hi

i use excel to publish various htm(l) files to shared drives for
access by about 100 people. the publish macro is set to run using an
Application.OnTime function and publishes a file (every 2mins) using
the code below:

ActiveWorkbook.PublishObjects.Add(xlSourceRange, _
"j:\am\tips.htm", "", "zone", xlHtmlStatic, _
"panEuro Risk_30594", "").publish (True)

on occassion the sheet notifies of an error requiring this line to be
debugged. often stoping the procedure and restarting it will do the
trick. however, when this doesn't work the only option is to change
the name of the file (above tips.htm would become something like
tips1.htm) because the original file is corrupt. this means notifying
all users to change their shared drive address...and this has happened
a few times in the past couple of weeks.

anyone know why this file could be corrupting itself only on certain
random occassions? if so, any ideas on how to prevent this?

all ideas are MORE THAN welcomed. cheers.