Capturing the path and name of the actual Excel file

[mtheriault2000]

Hello

Is there a function to capture the path and name of the actual Excel file running?

I got another application that communicate with my Excel sheet and it need to know the exact path for Excel file. Since I'm in development, I often save under a different name and the communication is stop. When doing that, I need to stop the other application, change the Excel path and name

If I could get the path and name, I will use External Global Variable to communicate it. This way, the link between them won't be cut

Any help appreciated
Martin

 

[Juan Pablo González]

ActiveWorkbook.FullName

will give you that.

 

[VoG]

In VBA like this

pf = ThisWorkbook.FullName

 

[mtheriault2000]

Martin