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