Altering Code to account for WB opened multiple times

Hey,

I have another issue that I'm hoping someone here can solve without too much effort. I had an earlier problem where I needed to move sheets from a workbook with the naming convention of "DDMMYY.xls" I solved that problem thanks to shg with the following code:

Please Login or Register  to view this content.

The issue I need help with is if the sheet has been opened multiple times, the naming convention of the file is changed to "DDMMYY(n).xls" Note the integer 'n' - I would like to somehow account for that.

So, a file typically named "050509.xls" opens fine and works in my macro perfectly, but if a file is named "050509(2).xls" or "050509(6).xls", the macro is not locating the file. Does anyone know any quick fixes to my issue? It is not a huge deal, if no answer is found, I can provide a disclaimer to users explaining the problem.

The (n) comes from closing and re-opening excel workbooks. So for example, the spreadsheet I use named "DDMMYY.xls" comes up normally the first time it is opened. But if the same spreadsheet is closed and re-opened multiple times without re-booting the computer, it begins to get a variable (n) depending on how many times it has been opened.

I think it has something to do with the spreadsheet being opened from an email. I get a daily email with this spreadsheet and open from outlook. Perhaps if it was saved first to the desktop it wouldn't get the (n), but I was looking for a way to continue opening from outlook.