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 |
All times are GMT +1. The time now is 10:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com