ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Publish to Web, Zero Values setting not saved (https://www.excelbanter.com/excel-programming/289861-publish-web-zero-values-setting-not-saved.html)

John Wilson

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