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 |
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 |
All times are GMT +1. The time now is 09:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com