Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Publish to Web, Zero Values setting not saved
Maybe someone has come upon this...maybe not.....
Nothing important, just a minor annoyance. I use the following (recorded, but it works) to "publish" a web page: ActiveWorkbook.PublishObjects.Add(xlSourceRange, _ "C:\DATA\WEB\NBPL\CurrTeamStandings.htm", "Standings", "$B$2:$P$64", _ xlHtmlStatic, "PoolSS_W2003_22910", "").Publish (True) The "Standings" sheet that is being published already has the "Zero Values" unchecked but the "published" copy doesn't. I have to open this up in Front Page, uncheck the "Zero Values" and save it. Any ideas on how to retain that setting in the published copy??? Thanx, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting values in a cell | Excel Discussion (Misc queries) | |||
Values In Links Not Being Saved | Excel Worksheet Functions | |||
Problem with setting values for SeriesCollection | Excel Programming | |||
Text Box - Setting Values | Excel Programming | |||
Setting values in another workbook | Excel Programming |