Xls execution path

[sarduspater]

I have some xls files who opens by vba txt or xls files for read/write.
How can I know the path of my xls program in execution?
Thanks.

Renato

 

[SkipVought]

Hi,

s = application.path

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

I'd use ThisWorkbook.Path

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

I was wondering why you want to know the path of Excel? But THAT is what you asked!

I agree that more than likely, you want to know where your workbook resides, which is not where the xls program is.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[sarduspater]

My workbook and xls program are in the same file.
I'm looking for his path.
ThisWorkbook.Path works fine, application.path returns excel.exe path.
Thanks to all.

Renato