Opening a worksheet in VBA
 

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/

Opening a worksheet in VBA
 

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/

Opening a worksheet in VBA
 

Precede it with

Application.Screenupdating = False

and set to True after.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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/

Opening a worksheet in VBA
 

works nice, thank you

--
Message posted from http://www.ExcelForum.com