Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy worksheet without opening the workbook
Hi all,
I would like ask if there's a way to copy a worksheet from a workbook A into workbook B, without actually opening workbook A? Thanks, Ben -- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy worksheet without opening the workbook
you can do it using formula.
try following: Sub GetData() Dim mydata As String 'data location & range to copy mydata = "='C:\[NewBook.xls]Sheet1'!$B$2:F12" '<< change as required 'link to worksheet With Worksheets(1).Range("B2:F12") '<< change as required .Formula = mydata 'convert formula to text .Copy .PasteSpecial Paste:=xlPasteValues End With Application.CutCopyMode = False End Sub -- jb "Ben" wrote: Hi all, I would like ask if there's a way to copy a worksheet from a workbook A into workbook B, without actually opening workbook A? Thanks, Ben -- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy worksheet without opening the workbook
See this site:
http://www.rondebruin.nl/ado.htm "Ben" wrote: Hi all, I would like ask if there's a way to copy a worksheet from a workbook A into workbook B, without actually opening workbook A? Thanks, Ben -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet activation on Opening Workbook | Excel Programming | |||
Can you copy a worksheet from a workbook wothout opening it? | Excel Programming | |||
Is there away to keep Excel from opening a copy of an already opened workbook and the pages not be at 100% but | New Users to Excel | |||
Copy to different workbook without opening it | Excel Programming | |||
Copy a worksheet without 'opening' workbook | Excel Programming |