Is it possible to import a whole sheet from one xls to another,
including the colours, layout and any comments associated with cells?

Thanks - Kirk

Kirk,
Open your source and destination WBs, then record a macro when you
right-click the WS to be copied Move or Copy Check the "Create a Copy"
box Select the "To book" and "Before sheet" options OK.
See the VBA code generated.

NickHK

"kirkm" wrote in message
...
Is it possible to import a whole sheet from one xls to another,
including the colours, layout and any comments associated with cells?

Thanks - Kirk

of course. just copy sheet.

Sheets("sheetname").Copy

regards,
julian

kirkm wrote:
Is it possible to import a whole sheet from one xls to another,
including the colours, layout and any comments associated with cells?

Thanks - Kirk

Click with your right mouse at the sheet you want to copy (I mean below
where you can click to the other sheets, sheet 1, sheet2,e tc..).
- Choose 'move or copy'
- Check create a copy
and select from the dropdown 'new book'

voila!

If you click in the left hand square, left click, then right click,
copy.

Go to the new workbook and select A1 and paste special - All, this
should do the trick.


To code it just record it.

Stopher

Hi Kirk,

Don't reinvent the wheel, "steal" some code:
http://www.erlandsendata.no/english/...batextimportwb

HTH,
Bernd