Reference another workbook sheet in current workbook

[Prashanth_Pasunuti]

Hello.
I have 2 workbooks named w1, w2. Macro was written in w1 and i want to reference a cell in a sheet of w2 workbook. How can i do it without opening sheet of w2 ?

Please help. Thanks in advance

 

[Prashanth_Pasunuti]

I have written code as

Dim wkb As Excel.Workbook
Dim wks As Excel.Worksheet

Set wkb = Excel.Workbooks("w2.xlsx")
Set wks = wkb.Worksheets("example_sheet")

'-----------------------------------------------------------

It is giving error as " subscript out of range" at set wkb statement.

 

[Marc L]

Hi,​

​

as the Set statement works only if the workbook is opened …​

 

[Prashanth_Pasunuti]

Hi,​

​

as the Set statement works only if the workbook is opened …​

hoo ok. I will verify and comeback. Thank you.