public property in one workbook, want to set value from anothe
A simple approach would be to define your variable in the "ThisWorkbook"
module:
Public s_Value As String
In the "controlling workbook:
Sub Tester()
Dim wb
Set wb = Application.Workbooks("Property1.xls")
wb.s_Value = "blah"
MsgBox wb.s_Value
End Sub
or show the code you have already.
Tim
"Mark VII" wrote in message
...
Hi Tim --
I've got the property GET and LET routines built in a class module of
workbook #2. Where I'm stumbling is the object references to manipulate
these
values from VBA that gets invoked in workbook #1.
Thanks,
Mark
The best way to do that might be to create a public sub in the workbook
and call that to set the property.
|