Selection or Activation of Another workbook

[fron]

Hi everyone,

I need help on how to improve my coding so that I can select the other workbook, just by mentioning the first name of my workbook. To be exact, this is my problem:

Please Login or Register  to view this content.

I dont want to put the whole of filename. I just want it to select any file name that begins with Expired.

Thanx in advance.

[royUK]

Will you have more than one workbook with Expired in the name open?

[fron]

Hye royUk

No. I may only open one workbook named Expired in a time. The thing is, my workbook is saved based on today's date. That is why i only need to select workbook that begins with Expired to be activated. FYI, i run the macro from the workbook named test which is the template or application. It then open the Expired workbook.

Thanx.