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

  • Thread starter Nic@Rolls-Royce
  • Start date
N

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
 
R

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