Macro to Run macro in another closed workbook

Hello there,

Change the text in red to the workbook you'd like to open's filepath, if you don't know it open the workbook and in a blank cell type =CELL("filename") this will tell you the filepath.

Please Login or Register  to view this content.

Then set the macro/code you want to run in the workbook you are opening to the workbook's on open event or the way the code is set up you can type the code you want to run before the .close False line

Originally Posted by j007conks

THis is a little old and hoping to get an answer. I am attempting to run a macro that I have in the second workbook and save it. The file is on a network folder and it is a database that I import test data into. I have the following code.

Please Login or Register  to view this content.

With copydataroutine being the macro I want to run in the database file.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread