D
drvortex
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").Publis
(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 particula
workbook.worksheet.cell. How could I set that up within the abov
script?
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").Publis
(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 particula
workbook.worksheet.cell. How could I set that up within the abov
script?