Application Path
 

How can I get the path of the Excel application from VBA code? This would be
like coding CurrentDB.Name in Access.

Thanks in advance,
--
Glenn

Application Path
 

It's in the title

ThisPath = application.Path

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Glenn Suggs" wrote in message
...
How can I get the path of the Excel application from VBA code? This would
be
like coding CurrentDB.Name in Access.

Thanks in advance,
--
Glenn