Find specific text within workbook's name, copy and paste it to specific cell

Hi,

I need to be able to find a specific text within changing-name workbooks, then copy that text and paste into a specific cell within the active sheet.

I work with workbooks that all have a different name, but all have a common format, something like:

"changingname-JA-restofname" Where a string of 2 letters will always be present and always after a dash (-). I need those 2 letters to be found, copied, and pasted into cell D2. I cannot use a count of characters from the beginning of the book's name, since they all have a different name and all have a different amount of characters before the "-".

I'll appreciate your help with this.

Thanks!

As per your example

Please Login or Register  to view this content.

Hi Jolivanes,

Your code is simple, yet effective. Works like a charm! Just have an additional question (since I didn't realize this earlier). How would the code be to only pick the first 2 letters of the book's name (and ignore the rest no matter what characters follow those 2 first letters) and paste it into the same cell (D2)?

Thank you SO much for your help!

Hi Leith,

My bad for not explaining correctly. Your code works with the sample given in my original post, but as you correctly pointed out, it doesn't when that pattern is missing.

The second scenario is when the book's name starts with the 2 letters needed, but is then followed by either letters or numbers w/o a dash, or there are dashes at other places within the name. These are 2 examples:

RG120563-ALLEN-12216

SM0235-STARMAN122016

In this case, I just need to pick the first 2 characters, which are the letters I need pasted into cell D2, then ignore the rest of the book's name.

Thank you again.

How would the code be to only pick the first 2 letters of the book's name (and ignore the rest no matter what characters follow those 2 first letters) and paste it into the same cell (D2)?

Please Login or Register  to view this content.

Jolivanes,

Your code works perfect. I appreciate when experts like you take the time to help others. Thank you So much!

I'm marking this post as solved.

Hi Leith,

Sorry for the confusion. Jolivanes replied to the second scenario, and that code worked for that. The code you posted in response to my original post worked for that first case. In this case, I thank you both for your help!

Thanks for letting us know.