Hi All

I want to put various content, some text, some graphic images, into consecutive worksheets of a new spreadsheet. I was thinking of automating the creation of a new xls file, copying the text (or the image) to the clipboard and then adding a worksheet, and then pasting the clipoard into the worksheet, then repeat for each block of text or image that I want to put into the excel file. How does one;

a) create a new worksheet,

b) paste the contents of the clipbaord into the worksheet created above

I could work it out with intellisense but I'm looking for best practice and suggestions as I need this ready for a presentation Monday morning :)

Thanks.