Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different Behaviour of Public Object Vars in Worksheets vs. Add-In
Excel 2000
In A workbook I declared a an object variable of type ADODB.Connection in the declarations part of a module as follows: Public pspDB as ADODB.Connection All functions and procedures using this variable work fine as long as the workbook is saved as .xls. However if I save it as Add-In (.xla) the variable seems not to be recognized as such. It's value seems to be an empty string (""). Before Initializing the variable I expect 'Nothing' as value. Can anybody give me a hint what I missunderstand here? Many, many thanks, Etienne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i assign the ActiveWorkbook.Worksheets to a worksheets object? | Excel Worksheet Functions | |||
functions & range vars | Excel Programming | |||
Worksheet wide vars | Excel Programming | |||
= How to setup vars when a workbookopen event is launched? | Excel Programming | |||
Global vars | Excel Programming |