Opening a worksheet in VBA

  • Thread starter Thread starter gwgeller
  • Start date Start date
G

gwgeller

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
 
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
 
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)
 
Back
Top