If that's the case you can refer to the new workbook with Workbooks(2).

By the way, there alternatives to SendKeys.

Don't have any links to hand but why not try a search?