Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a worksheet in VBA
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening worksheet | Excel Discussion (Misc queries) | |||
Opening Worksheet | Excel Discussion (Misc queries) | |||
Opening a worksheet | Excel Discussion (Misc queries) | |||
VBA Opening worksheet, name changes | Excel Discussion (Misc queries) | |||
Opening a New Worksheet | New Users to Excel |