VBA : Open XML file with XSL in Excel -

-

i open xml file vba language on excel, when it, xsl ignored. here code :

sub openfile() ' ' openfile macro ' name_file = application.getopenfilename("xml files (*.xml), *.xml") if name_file <> false     workbooks.open filename:=name_file end if ' end sub

thank answers

you need use openxml method instead:

workbooks.openxml filename:=name_file, stylesheets:=array(1)

Comments

Post a Comment

Popular posts from this blog

javascript - React.js: onClick function from child to parent -

-
i used this article example (react way), not working me. please point me mistake, can't understand what's wrong. this error see: uncaught typeerror: this.props.onclick not function here code: // parent var senddocmodal = react.createclass({ getinitialstate: function() { return {taglist: []}; }, render: function() { return ( <div> { this.state.taglist.map(function(item) { return ( <tagitem nameprop={item.name} idprop={item.id} onclick={this.handleremove}/> ) }) } </div> ) }, handleremove: function(c) { console.log('on remove = ', c); } }); // child var tagitem = react.createclass({ render: function() { return ( <span classname="react-tagsinput-tag"> <span>{this.props.nameprop}</span> <a classname='react-tagsinput-remove' onclick={this.handleremove}></a...
Read more

javascript - How to diff two immutable objects -

-
is there way diff objects in immutable ? example: let = immutable.fromjs({ a: 10 }); let b = immutable.fromjs({ b: 10 }); let d = immutable.diff(a, b); // { a: 10 } console.log(d.tojs()); this useful when testing see how objects differ. it doesn't have show what's added/removed explicitly. want see properties a differs b can make them equal again. for example this: console.log(a.tojs()); console.log(b.tojs()); and check logs see differs b. in other thought might show both added , removed properties in same output. main point see not equal. so be: // { a: 10, b: 10 } console.log(d.tojs()); or maybe: // { added: { a: 10 }, removed: { b: 10 } } // console.log(d.tojs());
Read more

c# - How can I have the VS Debugger break in the correct location for exceptions thrown in Async methods in a Console App? -

-
i'm writing console app uses lots of async methods; i've made async main method can await in: static void main(string[] args) { mainasync(args).wait(); } static async task mainasync(string[] args) { // can use await here } however, when exception occurs; debugger break me on .wait() call. not experience. is there can debugger breaks exception occurs rather here? i'm using vs2015 , targeting .net 4.6 if influences answer.
Read more