One way

Sub FindDrive()

MsgBox "The drive is " & Left(ActiveWorkbook.Path, 3)

End Sub

--
Ian
--
"CM" wrote in message
...
Is there an Excel function that captures which drive partition the
worksheet
is in (e.g., C:\, D:\, etc.) ?

Thank you,

CM