• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Get Value from a closed Workbook (

madocar

Member
Hello,

please, I have 1 Folder with more than 2 000 Excel workbooks.
I need to get value from each of them - cell B4 and B7.

Is there any way how to do that?

INDIRECT function does not help as far as I know - it does not work if the workbook is not open.

Thank you for any help
 
This video should get you on the right path. Of course you will need to modify it to only grab your selected cells.

 
Back
Top