Hello
I'm running into a problem with a macro I've created. The macro is currently stored in WorkbookA.xls. I have it prompting an open dialog box to open the file WorkbookB.xls and execute a series of commands. The problem is, the macro keeps failing after I've selected WorkbookB.xls from the Open dialog box. How do I activate WorkbookB.xls immediately after opening it?
Also, is this possible if WorkbookB.xls is a variable file name, for example, it's named WorkbookB.xls on a Tuesday, but WorkbookC.xls on a Wednesday?
I've run across this forum so many times in searching for my Excel troubles, this is my first post. Thanks in advance!
I'm running into a problem with a macro I've created. The macro is currently stored in WorkbookA.xls. I have it prompting an open dialog box to open the file WorkbookB.xls and execute a series of commands. The problem is, the macro keeps failing after I've selected WorkbookB.xls from the Open dialog box. How do I activate WorkbookB.xls immediately after opening it?
Also, is this possible if WorkbookB.xls is a variable file name, for example, it's named WorkbookB.xls on a Tuesday, but WorkbookC.xls on a Wednesday?
I've run across this forum so many times in searching for my Excel troubles, this is my first post. Thanks in advance!