VBA - Path of the excel file

A

abc2002

Hi all!

Fisrt of all, I want to thank you for your support :)

My question is: How can I get the path of the current Excel file in
VBA?

thanks
 
J

Jason Morin

Sub CurrDir()
Dim MyPath As String
MyPath = CurDir
MsgBox MyPath
End Sub

HTH
Jason
Atlanta, GA
 
Top