can't activate open workbook based on cell value

I have a spreadsheet that opens an excel file based on the value in a given cell. This works fine. However, I need to pass data from my form to this newly opened file. I can't seem to get this file to become the active workbook so I can complete my paste action. I mind you, the file is already open...so I'm rather puzzled why this isn't working. I have to call the file based on a variable, as the file names always change.

Please Login or Register  to view this content.

Thanks, JS

Thanks. Even that gets stuck at the same place, the paste function. It's selecting the range from the first workbook and doing the copy. But then it goes to debug mode when it goes to the line where the paste is, samething as with my original code.