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 |
Pull drive information into worksheet
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 |
All times are GMT +1. The time now is 01:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com