Hello all,

I want to enable my non-VBA friendly users to be able to change the
paths that various files are pulled from / saved to via Excel.

At the moment the paths are hard coded - they are of the non-geeky
variety (unlike me ;) ) and do NOT want to go into the VBA to change
them.

So I have made a table in Excel for them to enter the paths.

My project has many, many modules and subroutines. I can't declare and
set the variables to the path names once, as I'd have to do it in each
sub/module.

SO my question is - is there a way of making global constants which are
set up from stuff in the excel sheet (e.g. range("mypath").value )?

Or maybe there is a better way...?

Thanks for your help.

Brgds,
Graham


--
gearoi
------------------------------------------------------------------------
gearoi's Profile: http://www.excelforum.com/member.php...o&userid=26576
View this thread: http://www.excelforum.com/showthread...hreadid=400711