would like to copy from a worksheet in one workbook to a new worksheet in another workbook using VB and Excel 2007.
Also I am using late binding.. :)
So I can already open both workbooks
My quesitons are:
- how do I add a worksheet to a workbook
- how do I copy from a worksheet in a workbook
- how do I paste from that worksheet to another worksheet in a different workbook