Public variable lost...
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
|