View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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.