Reference a specific sheet in another workbook?

[TheWennerWoman]

Hello,

I have two workbooks open (as well as my file running the macro).

I am trying to reference one of them with

Dim shtData As Worksheet
Dim wb1 As Workbook

Set shtData = wb1.Sheets(3)  '<---errors here

But it errors with "Object variable or With block variable not set"

What am I doing wrong?

 

[offthelip]

you haven't set wb1 to anything

 

[TheWennerWoman]

you haven't set wb1 to anything

many thanks, coffee hasn't kicked in yet