How do I change a macro to call a sheet from another workbook

[Nic@Rolls-Royce]

Hi

This is proberably v easy, however I can't figure it



I use a VBA macro to call up some infor and part of it is

Worksheets("Gate A").Rows("10:3000").EntireRow.Hidden = False
Worksheets("Question Database [Q]").Range("con_control").Copy
With Worksheets("Question Database [Q]")



"Gate A" & "Question Database" Are now held in a workbook calle
'Database'

How do I amend the Macro to look at the sheet in the workbook rathe
than the workbook it is in now???


Thankyou in advance

Ni

 

[Rob van Gelder]

As long as Database workbook is already open.

Workbooks("Database").Worksheets("Gate A").R .... etc..


If it's not already openthen you could use this:

Workbooks.Open ("C:\Database.xls")

 

[Nic@Rolls-Royce]

Good Morning Rob

Once again, thankyo