Hi!
I want to publish tables and charts to a webpage using excel. I want excel to import the data periodiacally from a text file and thereafter publish them periodically to a webpage.
I've managed to get this working using a routine like this (plus excels dataimport function);
Sub Auto_Open()
ActiveWorkbook.PublishObjects.Add(xlSourceChart, _
"H:\timetest\ResponseDist.htm" _
, "Chart1", "", xlHtmlStatic, "DevXSample_16365", _
"Chart Title Goes Here").Publish (True)
Application.OnTime Now + TimeValue("00:05:00"), _
"Auto_Open"
End Sub
However, this only works as long as the workbook is open!
Is there any way of getting excel to do this while the workbook is closed? (may be a stupid question, but what the #¤¤%).
Any help greatly appreciated!
marsupilame
Bookmarks