Pass Workbook Name Into Another Workbook As A Variable
Hi!
"ThisWorkbook" property refers to the workbook who contains the code.
Use the "ActiveWorkbook" property.
John
Ο χρήστης "Minitman" *γγραψε:
Greetings,
I open one workbook which opens another workbook using the workbook
open event of the first workbook. The first workbook is the active
workbook. The first workbook's name is not always the same but it's
code is.
Is there a way that the name of the first workbook or a variable with
that name assigned to it, be used in the second workbook's code?
I tried ThisWorkbook but could not get it to work.
Any help would be greatly appreciated.
-Minitman
|