i need to copy a worksheet to another workbook. the problem is that i dont know what that workbook will be until i run my macro. so need a macro to ask the user to point to an excel workbook, then copy the worksheet over.

i know how to create a worksheet but not how to copy it to the other workbook (in VBA).

can someone help?