Pull drive information into worksheet

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

Thank you,

CM

One way

Sub FindDrive()

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

End Sub

--
Ian
--
"CM" <CM@discussions.microsoft.com> wrote in message
news:67437381-FB9D-4CAD-B850-3C6D0DE28081@microsoft.com...
> Is there an Excel function that captures which drive partition the
> worksheet
> is in (e.g., C:\, D:\, etc.) ?
>
> Thank you,
>
> CM