View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neon520 Neon520 is offline
external usenet poster
 
Posts: 129
Default "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