Thread: Web Saving Help
View Single Post
  #1   Report Post  
drvortex
 
Posts: n/a
Default Web Saving Help


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