File's name and recognition by the program

[rcprito]

hey guys.

I would like to know, if it is possible for vba to recognize the name of the file is into.

example:

You file's name is : Track

you change for : Music

Your code automatically recognizes that and change the code.

Can someone help me?

Thanks

[amromerodiaz]

Hello rcprito!

try this:

Please Login or Register  to view this content.

Thus... the name of your excel file is stored as NAME, instead of "Track" or "Music".

I hope this can help you,

Alvaro

[rcprito]

Thanks a lot mate!