Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA question - Copying Sheet from Workbook to another
Plz,
Which instruction I use to copy SheetX from Workbook A to Workbook B? Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA question - Copying Sheet from Workbook to another
Try something like
Workbooks("BookA.xls").Worksheets("Sheet1").Copy _ after:=Workbooks("BookB.xls").Worksheets("Sheet1") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ajliaks " wrote in message ... Plz, Which instruction I use to copy SheetX from Workbook A to Workbook B? Thanks --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA question - Copying Sheet from Workbook to another
WorkSheets("Sheet1").Copy
After:=Workbooks("Book1").Worksheets(Workbooks("Bo ok1").Worksheets.Count) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "ajliaks " wrote in message ... Plz, Which instruction I use to copy SheetX from Workbook A to Workbook B? Thanks --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping Workbook Name Out of Sheet When Copying to Different Book | Excel Discussion (Misc queries) | |||
copying one sheet to another workbook | Excel Discussion (Misc queries) | |||
Color formatting issue when copying excel sheet from workbook to o | Excel Discussion (Misc queries) | |||
When Copying a sheet, the whole workbook gets copied | Excel Discussion (Misc queries) | |||
Copying a Filtered Range from a Sheet in another Workbook | Excel Programming |