Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Publishing a static table as html using jscript (Excel 2007) | Excel Discussion (Misc queries) | |||
Programmatically determining corrupt excel files | Excel Discussion (Misc queries) | |||
Publishing to html is broken in Excel 2007 | Excel Discussion (Misc queries) | |||
Keep saving corrupt Excel files | Excel Discussion (Misc queries) | |||
Publishing Excel Files to a web page | Excel Discussion (Misc queries) |