ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   filisystem again (https://www.excelbanter.com/excel-programming/346759-filisystem-again.html)

alvin Kuiper

filisystem again
 
Hi

Is there away where i can see the drive name
i'm running the file from?

I have try whit filesystem getdrivename
but i can't get i to work

It shall juts returning the drive name where i running
the file from.

Hope someone can help

best redards

alvin


Don Guillett[_4_]

filisystem again
 
does this help?

Sub mypath()
MsgBox ActiveWorkbook.Path
End Sub

--
Don Guillett
SalesAid Software

"alvin Kuiper" wrote in message
...
Hi

Is there away where i can see the drive name
i'm running the file from?

I have try whit filesystem getdrivename
but i can't get i to work

It shall juts returning the drive name where i running
the file from.

Hope someone can help

best redards

alvin





All times are GMT +1. The time now is 08:30 PM.

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