Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User-changeable paths into Excel - avoid hard coding
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user-changeable drop-down lists | Excel Discussion (Misc queries) | |||
Protection password iin VBA, how to avoid user seeing it? | Excel Discussion (Misc queries) | |||
hard coding a cell | Excel Discussion (Misc queries) | |||
Avoid user having to enter 00 hours when using [mm]:ss format | Excel Discussion (Misc queries) | |||
Hard-Coding a File Location | Excel Programming |