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