Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
locate drive
Have code that looks for a file in (C:\) example open C:\ word.doc problem is
if a person places the folder with all files on another drive there is conflick. Lack knowledge as to how to have the C be any drive. Can it be done? Appreciate help Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
locate drive
There are lots of drive letters you'd have to search through (26 approximately
<bg). I think I'd look on the preferred location (C:\folder\folder\word.doc), and if not found, I'd ask the user. Jim Rech has a BrowseForFolder routine at: http://www.oaltd.co.uk/MVP/Default.htm (look for BrowseForFolder) John Walkenbach has one at: http://j-walk.com/ss/excel/tips/tip29.htm If you and all your users are running xl2002+, take a look at VBA's help for: application.filedialog(msoFileDialogFolderPicker) Curt wrote: Have code that looks for a file in (C:\) example open C:\ word.doc problem is if a person places the folder with all files on another drive there is conflick. Lack knowledge as to how to have the C be any drive. Can it be done? Appreciate help Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links to mapped drive change to refer to local hard drive | Links and Linking in Excel | |||
Import from MS Access - Lose the drive letter..link only to drive | Excel Programming | |||
Save to hard drive and backup to thumb drive. | Excel Programming | |||
Userform Local Drive & Network drive question | Excel Programming | |||
Pasting a range of information from a foler on F Drive to another folder on same drive | Excel Programming |