IceBox Posted August 2, 2016 Report Share Posted August 2, 2016 Does anyone know if this can even be done? Here is what I am trying to do: Use Macro Express to gather some information from an application Have Macro Express then activate an Excel file that is already open. Once Excel is activated, I want a VBA macro in the Excel file to automatically be triggered (to clear the sheet) I then need Macro Express to fill out two cells from the info it gathered at the start of the macro. Finally, activate a second VBA macro that is already programmed. I have found some code online that seems to work when the file is closed. When the file is open, I get an error stating that I already have it open. In other words, it is looking at the VBScript in Macro Express as another person trying to access the same open file, and will only allow it if I close the file. I already have each of the Excel VBA macros assigned to buttons on the sheet. So having Macro Express click the button would be just as helpful as triggering the VBA macros, as it would achieve the same result obviously. (From what I can tell, the buttons are not recognized by the Get Control tool in Macro Express, or this would've be too easy) Please help. I am out of ideas... 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.