How could i get the full path name of running word or power point file by VB or VBA

Question

I need to copy file from pen drive which file is running from pen drive. This soft must be running in background.

Pls, Send me the code of getting running office pile path.........

Answer 1

I'm not sure exactly what you want.. but if you want the path to the Excel.exe in Excel VBA use Application.Path eg;

MsgBox Application.Path

Answer 2

For Word, according to MSDN, it's ActiveDocument.FullName. For PowerPoint, my MSDN-fu says you should try ActivePresentation.FullName.