Thread: VBA question - Copying Sheet from Workbook to another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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/



Reply With QuoteReply With Quote