ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Web Saving Help (https://www.excelbanter.com/excel-worksheet-functions/5483-web-saving-help.html)

drvortex

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



All times are GMT +1. The time now is 09:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com