Excel publish multiple sheet using VBA -


i trying publish multiple sheets in excel using vba. need publish sheet 2 , 3.

below code.

with activeworkbook     .weboptions.allowpng = false         .publishobjects(2)             range("a1").activate             .filename = "d:\reports\09192014\mnm.html"             .publish (true)         end end

in publishobjects(2) changing number 2 3 manually below.

with activeworkbook     .weboptions.allowpng = false         .publishobjects(3)             range("a1").activate             .filename = "d:\reports\09192014\coal.html"             .publish (true)         end  end

still though, in html report coal.html getting mnm.html data , has half of data.
how can iterate sheets , publish objects?

shouldn't adding first this?:

    activeworkbook.publishobjects.add(xlsourcesheet, _         "d:\reports\09192014\mnm.html", "sheet1", , _         xlhtmlstatic, , "")         .publish (true)         .autorepublish = false '~~> true updates html when workbook saved     end      activeworkbook.publishobjects.add(xlsourcesheet, _         "d:\reports\09192014\coal.html", "sheet2", , _         xlhtmlstatic, , "")         .publish (true)         .autorepublish = false     end

after adding it, time can access using publishobjects collection via index number.
index based on sequence object created.


Comments

Post a Comment

Popular posts from this blog

Regex find and replace between <div class="customclass"> and </div> tag -

i cant find anywhere working regex expression find , replace text between div tags so there html want select between <div class="info"> , </div> tag , replace other texts <div class="extrauserinfo"> <p>hello world! sample text</p> <javascript>.......blah blah blah etc etc </div> and replace with my custom text codes <tags> asdasd asdasdasdasdasd</tags> so <div class="extrauserinfo"> custom text codes <tags> asdasd asdasdasdasdasd</tags> </div> here refiddle code there , can see want replace whole bunch of codes between , tag http://refiddle.com/1h6j hope mean :) if there's no nesting, plain match non-greedy (lazy) (?s)<div class="extrauserinfo">.*?</div> .*? matches amount of character (as few possible) meet </div> used s modifier making dot match newlines too. edit : here javas...
Read more

jpa - Passing entitymanager from reflection method -

we using struts2, ejb jpa. @persistencecontext private entitymanager entitymanager; // here getting entitymanager reflection method m = c.getdeclaredmethod(methodname, params); //here params accept class<?> now want pass entitymanager using reflection. how pass entitymanager in getdeclaredmethod ? billy, reply. now fixed issue using transactionscopedentitymanager. we using struts2 + ejb + jpa 1.0 (cmt). have many action classes , form values persist in db. created ejb every 1 action. planing 1 ejb action classes. go reflection. using getdeclaredmethod, can pass method name , params. here params accept classes. need pass our form object , entitymanager. used entitymanager type, changed transactionscopedentitymanager.
Read more