Extracting characters from a work book filename

Hi All,

I am trying to extract 2 characters from a workbook when running a code:

I have this so far:

Please Login or Register  to view this content.

The format of the book name is:

Team Install Report Week 30
Team Install Report Week 31 etc, so it returns 30, 31 etc.

When the workbook is named :
"Team Install Report Week 09", I only want to return 9, but I thing with the "0", "" is where I am going wrong. Can anyone offerup any assistance?

Thanks
John

Does this help?

Please Login or Register  to view this content.

I have now done this like this:

Please Login or Register  to view this content.