ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Test whether current drive is local or remote? (https://www.excelbanter.com/excel-programming/275853-re-test-whether-current-drive-local-remote.html)

keepITcool

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")?




All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com