Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to access a function from a different workbook
Hi everyone.
I have 2 worksheets, say Workbook1 and Workbook2. I have a routine in Workbook1 which needs to retrieve a value from Workbook2. For example in Workbook1 I have: Sub GetValueFromWorkbook2() Dim val as Integer val = Application.Run ("'Workbook2.xla'!GetValue") MsgBox (val) End Sub and in Workbook2 which is also opened and acquired certain values before call from Workbook1, I have: Private val as Integer Private Sub Workbook_Open() val = 5 End Sub Public Function GetValue() GetValue = val End This would display 0, instead of 5. So, how will I get the correct value? Thanks in advance. :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbook to access | Excel Programming | |||
Access Data from Workbook without seeing the workbook open. | Excel Programming | |||
link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
Function "User()" to provide access to workbook | Excel Programming | |||
Can't access to a WorkBook | Excel Programming |