Cant get wild card ...*... to work in Excel VBA .

[orozvik]

I have a spreadsheet name that varies the number in paranthasis, but the rest of the name is the same.

Thus, Bank Transaction Reconciliation will always be the same, however the number will change as new files are accessed by the macro. Thus, i need the macro to use a wild card inside the parenthasis to pull up different files.

Here is examples of how the files will vary....

Bank Transaction Reconciliation (28).xls
Bank Transaction Reconciliation (29) .xls
Bank Transaction Reconciliation (40) .xls ....so only a very small part of the file name will vary and this small piece needs to be a wild card. But i can't get the following

code to work.........

Windows("Bank Transaction Reconciliation (& " * " &) .xls").Activate.............can you help me? thank.s

[shg]

Please Login or Register  to view this content.

[orozvik]

Thank you very much....the code you provided worked like a charm.