excel - Use Destination Theme & Embed Workbook (h) -

-

i trying copy chartobject created in workbook sheet , paste powerpoint 2010 slide, such becomes standalone excel chart data (embedded).

when manually i.e :

  1. copy chartobject present in worksheet
  2. goto powerpoint slide
  3. click pastespecial & select "use destination theme & embed workbook (h)".
  4. right-click chartobject in powerpoint & click "edit data".

then new standalone workbook title "chart in microsoft excel", shows chart data. have not been able replicate scenario new standalone workbook title "chart in microsoft excel" using excel vba. can help?

assuming there simple column chart on sheet, here code:

option explicit sub doit() dim temp workbook dim rng range dim chtobj chartobject  thisworkbook.sheets(1)     set chtobj = .chartobjects(1)     chtobj         .copy     end      dim ppapp object     dim pppres object     dim ppslide object      on error resume next     set ppapp = getobject(, "powerpoint.application")      if ppapp nothing         set ppapp = createobject("powerpoint.application")     end if     on error goto 0      set pppres = ppapp.presentations.add     set ppslide = pppres.slides.add(1, 12)      ppapp         .activate         .visible = msotrue         .activewindow.viewtype = 1     end      chtobj.copy     ppapp.activewindow.view.paste  end end sub

there appears no corresponding method in powerpoint object model.. way call ribbon button itself:

application.commandbars.executemso("pasteexcelchartdestinationtheme")

btw: find list of ribbon buttons, search "office 2010 control ids".


Comments

Post a Comment

Popular posts from this blog

javascript - Count length of each class -

-
i have below code in this fiddle . html <span class="myname">john smith</span> <span class="myname">john smith</span> <span class="myname">john smith</span> <span class="myname">john smith</span> <span class="myname">john smith</span> <span class="myname">john smith</span> javascript $('.myname').each(function(){ var text = $(this).html().split(' '), len = text.length, test = $(this).val().length, result = []; console.log('outside: ' + test); for( var = 0; < len; i++ ) { result[i] = '<span class="name-'+[i]+'" >' + text[i] + '</span>'; console.log('inside: ' + test); } $(this).html(result.join(' ')); console.log('after
Read more

What design pattern is this code in Javascript? -

-
this question has answer here: why write “.call(this)” @ end of javascript anonymous function? [duplicate] 4 answers what kind of design pattern , significance of using closure? (function(){ // code here }).call(this); edit then difference between above code , following this keyword still refer same object in both ways. (function(){ // code here })(); thats invoked function expression. more info here: http://benalman.com/news/2010/11/immediately-invoked-function-expression/ the purpose run code while protecting scope (so variables declared within don't leak out global scope. update call sets value of this function being applied on. without it, value set window object, there set outer scope.
Read more

hadoop - Restrict secondarynamenode to be installed and run on any other node in the cluster -

-
i have have cloudera cdh3u4 cluster setup. have secondarynamenode daemon running on 1 of nodes. i have ensure user has root access node on cluster (for example, datanode not have other daemons running) should not able start instance of secondarynamenode daemon on node (thereby having 2 secondarynamenodes on cluster) how can achieve this? thanks in advance. add property hdfs-site.xml namedfs.secondary.http.address valuesecondarynamenode-host address or ip:50090
Read more