mtomas Posted March 15, 2010 Report Share Posted March 15, 2010 I run an extraction software that extracts data from websites and places all the data in a grid then saves the grid(spreadsheet) as an excel file on my desktop automatically with the same name everytime.. (i eventually rename this file once i process it myself in excel) i am trying to run a macro and have this event (when this file.xls is saved onto my desktop) activate my macro. I have toyed with the directory modification but that doesnt seem to trigger the macro... Has anyone tried this activation trigger ? basically once this file.xls appears saved on my desktop, that should trigger my macro to run. any help would be appreciated. thanks Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.