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


--
marsupilami
------------------------------------------------------------------------
marsupilami's Profile: http://www.excelforum.com/member.php...fo&userid=2698
View this thread: http://www.excelforum.com/showthread...hreadid=390154