Below is macro that works.
Sub saveweb()
'
' saveweb Macro
' Macro recorded 10/31/2004 by NORENJ
'
'
ActiveWorkbook.PublishObjects.Add(xlSourceSheet, _
"C:\Documents and Settings\Drvortex\Desktop\Jan04.htm",
"Jan04_Charts", "" _
, xlHtmlStatic, "2004_ChartsA_4129", "Jun04_Charts").Publish
(True)
End Sub
However, the RED items are the items that I would like control over.
I would like to reference each of those items to a particular
workbook.worksheet.cell. How could I set that up within the above
script??
--
drvortex
------------------------------------------------------------------------
drvortex's Profile:
http://www.excelforum.com/member.php...o&userid=15896
View this thread:
http://www.excelforum.com/showthread...hreadid=274408