I am trying to write code to prompt a user then copy and paste.

[Kyle Pellum]

I am trying to write code to copy and paste a worksheet from one workbook to another. The thing I cannot figure out is how to reference the workbook to be copied because the name will be different when this macro is run, as it is for monthly reporting. The workbook it is to be copied into is titled Monthly TAC Builder, sheet is Last Month. I dont know how to write the code without a certain name for my sheet to be copied from.

Thanks

[Guido Geurs]

Attached is an example how You can copy a sheet from an other workbook.(This is only for testing the code) !

how it works:
- Open de file Book1.xls
- select a date in cells A1...A5
- click on Commandbutton1