Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workbook Highlighting property ChadF Excel Programming 2 October 9th 06 06:55 PM
Workbook Property or Method Gary''s Student Excel Programming 3 February 17th 06 03:11 PM
workbook.saved property Jan[_17_] Excel Programming 2 November 22nd 05 05:07 PM
Calling a Public Subroutine in a Different Workbook Raul Excel Programming 2 August 24th 05 04:27 AM
Workbook-level public variables Stefi Excel Programming 7 May 9th 05 03:58 PM


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"