Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Windows API to Determine if File is Local/Convert Path to Drive Letter
Hi all,
I'm working on a userform in Excel that relies on the common file dialog windows api. Once the user selects a file, I need to determine if the selection is valid or not. Basically, I need two additional Windows APIs: one to determine if the file the user selected is stored on the local machine or on a network share, and another to convert the fully qualified name (\\server\folder) to the drive letter alias set up on the local machine (i.e. o:\ in this case). Has anyone used APIs like this/have a link to a site that would have these APIs documented? (I rarely use Windows APIs, so I need the VBA implementation of them if possible.) Thanks, Johnny |
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 | |||
How to show the drive letter in the path on the title bar? | Excel Discussion (Misc queries) | |||
How do I get the true path to server (not mapped drive letter)? | Excel Worksheet Functions | |||
Hyperlinks - Move file to local drive, all links break | Excel Discussion (Misc queries) | |||
Using path instead of drive letter | Excel Programming |