Get File Name into String

[qcity]

Hey all,

Was wondering if there is a way for me to get the file name of my current active file into a string? I need it for a document I'm making but it may be constantly renamed. This is to avoid constantly changing the line in my VBA code from:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

Can this be done?

[mrice]

Not totally sure what you are after but you might be able to make use of some of the following objects..

Please Login or Register  to view this content.

[royUK]

Maybe

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.