Calling Value from Closed Workbook

[tjiddy89]

Is there any way to call a cell's value from an external workbook without the need to have the source workbook opened?

For instance the below code throwing "Run-time error '9': Subscript out of range".

Workbooks("wb1.xlsx").Sheets("Sheet1").Range("A1") = Workbooks("wb2.xlsx").Sheets("Sheet1").Range("A1")

 

[tjiddy89]

bump-arooski

Anyone have anything?

 

[tjiddy89]

Nevermind. I was able to figure it out.