Get the name of the workbook that you open

[stojko89]

Hi!

So did a little internet searching and made this code.

Please Login or Register  to view this content.

Works great.
But my problem here is I want to contiue on with:

Please Login or Register  to view this content.

So my question is how can I get the name of the workbook that I open.
If I use MsgBox sFilename <---- then it gives me the U:\Full\Path\Filename.xlsm But all I need is Filename and since the path is different for each file I cant just Trim the path away
It works If I use ActiveWorkbook.Name but since I don't want the workbook I open to be activated I want to somehow use the name to define the range.

Can some one help me with this please?

[Andrew-R]

Perhaps something like this:

Please Login or Register  to view this content.

[stojko89]

Hi Andrew-R

Thanks for the help!
But I just figured out that I won't be using this macro....

There's a lot info missing in the opend workbook for me to inport / update the info in the workbook this macro would be in.
So I'll have to manuly copy stuff from one wb to the other

But Thanks for the help!