Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving as web page for workbook with frozen panes | Excel Discussion (Misc queries) | |||
Saving Bond Wizard. Old Versions I Could Copy the data | Excel Discussion (Misc queries) | |||
how do I stop warnings when saving .xls as csv? | Excel Discussion (Misc queries) | |||
Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) | |||
Error Message appearing when saving a file | Excel Discussion (Misc queries) |