| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying and pasting entire workbook
Dave Peterson wrote:
*Workbooks(2).Worksheets.Copy _ after:=workbooks(1).worksheets(1) will copy the sheets to workbooks(1). Dave Peterson * The thing is, I need to replace the sheets in workbooks(1) with th corresponding sheets in workbooks(2), not just paste them as ne sheets. I have a working (but really ugly) solution. I can copy and paste cel by cell, and everything in the workbook (graphs etc) get update correctly. This is what I have now: Code ------------------- Workbooks.Open sFname Workbooks(2).Worksheets("Sheet1").Range("C11").Cop y Workbooks(1).Worksheets("Sheet1").Range("C11").Pas teSpecial Transpose:=True Workbooks(2).Close False ------------------- I want to do this for all cells in all worksheets. Thankyou -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying and pasting links within the same workbook | Excel Worksheet Functions | |||
| Copying/Linking Entire Workbook | Excel Discussion (Misc queries) | |||
| Copying store numbers and pasting them into a seperate workbook | Excel Discussion (Misc queries) | |||
| Copying and pasting ??? | Excel Discussion (Misc queries) | |||
| Copying & Pasting | Excel Programming | |||
![phreud[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
