Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workbook Highlighting property | Excel Programming | |||
Workbook Property or Method | Excel Programming | |||
workbook.saved property | Excel Programming | |||
Calling a Public Subroutine in a Different Workbook | Excel Programming | |||
Workbook-level public variables | Excel Programming |