Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Sheet
What's the best way to move a whole sheet from one .xls to another? Can you click and drag ? Or use code ? The move, insert, copy options seen to be only within the same .xls Thanks - Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Sheet
The code found here works well for me.
http://www.rondebruin.nl/copy7.htm "kirkm" wrote: What's the best way to move a whole sheet from one .xls to another? Can you click and drag ? Or use code ? The move, insert, copy options seen to be only within the same .xls Thanks - Kirk |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Sheet
hi
manually, coping the sheet then pasting it into a new book works good. with code... Sub addmore() ActiveSheet.UsedRange.Copy 'Cells.Copy' or copy the whole sheet Workbooks.Add 'Worksheets.Add'or to a new sheet in the same book Range("A1").PasteSpecial xlPasteAll msgbox "Done" End sub which is best? both work....how often do you do this or need to do this? Regards FSt1 "kirkm" wrote: What's the best way to move a whole sheet from one .xls to another? Can you click and drag ? Or use code ? The move, insert, copy options seen to be only within the same .xls Thanks - Kirk |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Sheet
Many thanks for the help, guys. I did have difficulty with both suggestions though.... then I figured out how the in-built Move/Copy dialog worked. Instead of 'Move Selected sheet" (which you don't do) it should say 'Move Active sheet' then the Before Sheet list and the To Book dropdown all starts to make sense. Cheers - Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing a Sheet | Excel Programming | |||
Importing excel sheet | Excel Discussion (Misc queries) | |||
importing data from other sheet | Excel Discussion (Misc queries) | |||
importing on protected sheet? | Excel Worksheet Functions | |||
Importing a sheet? | Excel Programming |