Return current file name

T

tdabel

Good day.

I am trying to retrieve the file name of an open document prior to it
closing. I am using Application.FileSearch.FileName to attempt to retrieve
the file name. When I step over it I'm only havea NULL value in my variable.

Thanks in advance for you assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top