I have a VBA program that works with multiple Workbooks. I create a new Workbook named ExportTemp.xlsx save it and then switch back to my
MainWorkbook.xlsm. I label my MainWorkbook with version names like MainWorkbook-120.xlsm.
Is there a way to activate MainWorkbook-120.xlsm with just:
Please Login or Register to view this content.
Please Login or Register to view this content.
If your main workbook is the workbook that contains the VBA code, you can refer to it using the ThisWorkbook keyword regardless of its name.
So...
ThisWorkbook.Activate
..will activate the workbook that contains the code.
Also, you could assign a workbook variable to the new workbook and use the variable to reference the new workbook.
Please Login or Register to view this content.
Last edited by AlphaFrog; 04-18-2018 at 09:42 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks AlphaFrog! Your assumption is correct, "MainWorkbook" contains the VBA Code.
Could I not just replace:
With...Please Login or Register to view this content.
In my original code to be...Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks