Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global vars
Hi.
I have a global variable that holds the file name and path of a database that i am retrieving data from to return to excel. However, without DIM'ing the variable again anywhere in the modules associated with the spreadsheet. I keep losing my global variable's value Any ideas? TIA Nath |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global vars
Make certain the the global varaible is declared in a regular module, not a
worksheet or a dialog's module. Bob Flanagan Macro Systems Delaware, U.S. 302-234-9857 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Nath" wrote in message ... Hi. I have a global variable that holds the file name and path of a database that i am retrieving data from to return to excel. However, without DIM'ing the variable again anywhere in the modules associated with the spreadsheet. I keep losing my global variable's value Any ideas? TIA Nath |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
global changes | Excel Worksheet Functions | |||
Global Calculation ??? | Excel Discussion (Misc queries) | |||
Global Defaults | Setting up and Configuration of Excel | |||
global Macros | Excel Discussion (Misc queries) | |||
Global Macro | New Users to Excel |