Display workbook name

[kelly mort]

Hello All,
I need a macro to show me the name of my active workbook in a message box.

I want to use that to do something Else that's very complex I can't explain here. So I just wanna know how to get the message box display that then I implement it.

Thanks
Kelly

 

[FormR]

You could simply try:

Msgbox(Activeworkbook.Name)

 

[kelly mort]

You could simply try:

Msgbox(Activeworkbook.Name)

Okay nice.

But one last thing:

I want to remove the last four characters from the name

 

[FormR]

I want to remove the last four characters from the name

You could try something like..

Msgbox(Left(Activeworkbook.Name,LEN(Activeworkbook.Name)-4))

 

[kelly mort]

You could try something like..

Msgbox(Left(Activeworkbook.Name,LEN(Activeworkbook.Name)-4))

Great. Thanks very much. I appreciate it.

Kelly