Importing a Sheet

[kirkm]

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

 

[NickHK]

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

 

[julian]

of course. just copy sheet.

Sheets("sheetname").Copy

regards,
julian

 

[Johan]

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!

 

[Stopher]

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

 

[bplumhoff]

Hi Kirk,

Don't reinvent the wheel, "steal" some code:
http://www.erlandsendata.no/english/index.php?d=envbatextimportwb

HTH,
Bernd