Hi
Try something like this
Sub test()
Dim Wb1 As Workbook
Dim Wb2 As Workbook
Application.ScreenUpdating = False
Set Wb1 = ActiveWorkbook
Set Wb2 = Workbooks.Open("C:\data\a.xls")
Wb2.Sheets("Sheet1").Range("A1:C1").Copy _
Wb1.Sheets("Sheet1").Range("A1")
Wb2.Close False
Application.ScreenUpdating = True
End Sub
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl
"gwgeller " wrote in message ...
Hello all. From a active worksheet I would like to open another
worksheet(in VBA) in a separate workbook and copy it's contents to the
initial worksheet. I would like this to happen without the 2nd
worksheet showing at all. Can I grab the contents of the other
worksheet without it actually opening in excel(visually)?
I can open the worksheet copy its contents and then close it,
but I don't want the user to see this happening.
Thanks,
GG
---
Message posted from http://www.ExcelForum.com/