Directory of Current Application 2

[mveera]

Hi,

I would like to know how i can get the current directory from where an Excel Application is Executed (Excel File location). The "CurDir" function returns the current working directory set, which could be other than the location where the file is. But i would like to know where the file is located.

Thanks
Veera

 

[Zathras]

Sub test()
  MsgBox Application.Path
End Sub

 

[SBendBuckeye]

If you are talking about the Excel workbook, lookup these properties: ActiveWorkbook.FullName, ActiveWorkbook.Path.

If you are talking about the Excel application, lookup this property: Application.Path, ActiveWorkbook.Application.Path.

Good Luck!