Extract data from closed external workbook

[Retroshift]

Hi,

How can you extract the entire sheet data from a closed external workbook whereby the path name of the external workbook is mentioned in a cell in the open workbook?
I guess you need VBA for this?

 

[Micron]

Yup. But you can't get info from something that isn't open. At the very least you'd have to open but keep it hidden.

 

[Retroshift]

It seems like in this post you can extract data from a closed workbook, no?:
How to import values based on week number criteria from a closed workbook to an active workbook

How can I extract a sheet from an closed workbook as referred to in a cell of the open workbook?
Thanks

 

[johnnyL]

Dim wbs1 As Workbook: Set wbs1 = Workbooks.Open(MyDocsPath & "\\Scheduled_Tasks_2022.xlsx")

That line of code is opening the workbook.

Your intentions are not clear. Are you simply stating that the workbook will be closed to begin with, or are you actually trying to get the information while the workbook remains closed?

 

[Retroshift]

I would like to extract the data from the external workbook (regardless of whether it is open or closed (if it is closed it should be closed again after opening it with VBA - if it was already open it can stay open)) with the location path of the workbook mentioned in a cell of the open base workbook.