Copy range from another workbook with wildcards

Hi All,

I'm attempting to write a macro to copy a range from another open workbook, then paste that data into the workbook that the macro is in. What I have so far works fine in tests, but in the real world there will be some variables I need to address.

There may be other open work books at the time the macro is run.

The entire target workbook name will be unkown, but will always contain "Changes"

The entire target worksheet name will be unkown, but will always contain "Changes"

Here is the code I am working with:

Please Login or Register  to view this content.

Any help would be greatly appreciated, thanks!

Originally Posted by xlbiznes

try using the like function :

Please Login or Register  to view this content.

Apply the same logic for the worksheet.

Hello xlbiznes thanks for the reply!
This is what I have so for, but I am getting a 'Next without For' error now.

Please Login or Register  to view this content.

Originally Posted by xlbiznes

shall i also include the code to check the sheet name for the like condition "*Changes*" ?

Yes please, it would help me out greatly.

Thanks!

Originally Posted by xlbiznes

here you go,

This is perfect, thank you very much, this really helped me out!

Marking this as solved!