| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automate copy and paste whole workbook to new workbook
Hey leslie,
If you want to copy a sheet from one workbook to another workbook and save the destination workbook, you can easily use the macro recorder. Think this is how it should look like. Sheets("Sheet1").Select Sheets("Sheet1").Copy Befo=Workbooks("destination.xls").Sheets(1) wkbk.Close SaveChanges:=True MsgBox ("DONE!") Greetz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy workbook to 2nd workbook paste is greyed out | Excel Worksheet Functions | |||
| copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) | |||
| Automate Cut & Paste Rows to different tab in Workbook | Excel Programming | |||
| Need a macro to copy a range in one workbook and paste into another workbook | Excel Programming | |||
| Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
Threaded Mode
