vba - Excel Macro needed which can check the downloads folder and delete all the files except the latest downloaded file -

-

i want make excel file following steps:

  1. delete excel files downloads folder except 1 latest downloaded file.
  2. make copy of excel file names "data.xls" , system makes "beep" sound
  3. repeat above mentioned 2 steps every 15 minutes

i can in visual basic unable implement in excel macro...

please help.. promotion depends on :-)

set reference microsoft scripting runtime. images below shows classes available in object browser. use file-related tasks in vba. did research & microsoft scripting runtime standard on windows should have it

enter image description here


Comments

Post a Comment

Popular posts from this blog

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

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

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