Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test whether current drive is local or remote?
you need a reference to Microsoft Scripting Runtime
then something like: Function DT(sPath As String) As String Dim fso As New Scripting.FileSystemObject Dim fsd As Scripting.Drive Set fsd = fso.GetFolder(sPath).Drive DT = Choose(fsd.DriveType + 1, _ "unknown", "removable", "fixed", "remote", _ "cdrom", "ramdisk") End Function keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Julian Milano" wrote: How can I test if the workbook's path is a local path or remote path (like on another PC called, say, "\\JDMils\C\My Documents")? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links to Local Drive Instead of Same Folder | Excel Discussion (Misc queries) | |||
Links to mapped drive change to refer to local hard drive | Links and Linking in Excel | |||
Coping Embedded documents to local drive... | Excel Discussion (Misc queries) | |||
Hyperlinks - Move file to local drive, all links break | Excel Discussion (Misc queries) | |||
Pasting a range of information from a foler on F Drive to another folder on same drive | Excel Programming |