Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Soft Code" Find File Directory Or Alternative
Hi everyone,
I was told about how to "Hard Code" a File Directory to Open All files in one particular folder. My concern is what if the users Rename the folder or Move the folder to a different location, then "Hard Code" won't work properly. 2 Method I could think of: 1. How to "Soft Code" it so that user can "BROWSE" the folder location once it's been MOVED or REMOVED. (Something similar to Mail Merge Feature in MS Word, there is an "option" for user to Browse to folder location Or and "Exit" to quit the operation) 2. Is there a way to prevent the user to move or rename the folder, frankly LOCK the folder? (I know this is somewhat outside the scope of this forum, but I'm going to ask it anyway) FYI, I'm using Office 2004 for Mac. Neon520 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Import data from other Excel file if file ends with "[directory][filename].xls" | Excel Programming | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
I get message "cannot find directory" with ExcelTools Menu | Setting up and Configuration of Excel | |||
NEWBIE: How can I do a "soft reference" in Excel/VBA? | Excel Programming |