ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Name of workbook (https://www.excelbanter.com/excel-programming/271094-name-workbook.html)

Andrew Ofthesong

Name of workbook
 
Hi, if i have 2 open workbooks: wb1 and wb2, and i have a macro in wb2 named
"MacroOnWb2"

How can i make a reference to worbook wb2 independentlly if i',m running the
macro having wb1 as active workbook or wb2?

PD: supouse i perhaps rename the workbooks, so "workbooks("wb2")" is also
not the ebst idea...




All times are GMT +1. The time now is 04:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com