LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F daves Excel Discussion (Misc queries) 3 April 24th 07 04:52 AM
Import data from other Excel file if file ends with "[directory][filename].xls" skusey Excel Programming 1 September 3rd 06 07:29 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
I get message "cannot find directory" with ExcelTools Menu RonDennis2002 Setting up and Configuration of Excel 2 January 4th 06 11:33 PM
NEWBIE: How can I do a "soft reference" in Excel/VBA? Dave[_29_] Excel Programming 1 September 8th 03 06:30 PM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"