How do I GetCurrentDirectory in Excel?
Hi Thunderbolt
if you want to have the drive letter (only the letter) you could use
following:
=LEFT(CELL("filename",A1),1)
otherwise to get the whole path, just use the cell function i used.
hth
Carlo
On Jan 18, 10:10*am, Thunderbolt2000
wrote:
I need to retrieve the current drive letter to use in my Excel spreadsheet,
how do I retrieve it?
|