Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I wonder if anyone has encountered the same problem? ( probably huh... : ) ) From a sub in a workbook saved in Excel2003, I open a second (template) workbook saved in Excel2k. After opening the workbook I call a sub by Application.Run to set a global variable in the opened workbook but after exiting the sub in the original workbook, the global in the opened workbook is reset (or lost). See example code below: Public Sub CallTest() Call Workbooks.Open(ThisWorkbook.Path & "\Test.xls") Call Application.Run("Test.xls!Test", blnTest) End Sub Is it a known bug? Does anyone know how to work around the problem without having to save the workbooks in the same Excel version. If the workbooks are saved in the same version of Excel, the problem will not occur! I have already tried that... Thak you! //Anders SWE |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Public variable | New Users to Excel | |||
Public Variable not maintaining value. | Excel Programming | |||
Public Variable in ThisWorkbook | Excel Programming | |||
Public Variable | Excel Programming | |||
public variable | Excel Programming |