I want to know if it is possible to retrieve data from excel sheets automatically without making any changes. This is the document link that i want the document to be like: [https://www.dropbox.com/s/a3pl7ets703ohxy/TOP%20Sheet%20.xls?dl=0] And, this is the link to the type of document that i want to retrieve information from: [https://www.dropbox.com/s/6w762lej2bqh2wu/367100.xls?dl=0] Is there anyway that i can automatically retrieve these information from hundreds of files? Thanks to all for any help.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Collecting Data from Unknown Workbooks

Thread starter Shahreaz
Start date Apr 19, 2016
Tags

retrieve separate unknown unknown wokbook unknownsheet

Shahreaz

New Member

Apr 19, 2016

I want to know if it is possible to retrieve data from excel sheets automatically without making any changes.
This is the document link that i want the document to be like:
[https://www.dropbox.com/s/a3pl7ets703ohxy/TOP Sheet .xls?dl=0]

And, this is the link to the type of document that i want to retrieve information from: [https://www.dropbox.com/s/6w762lej2bqh2wu/367100.xls?dl=0]

Is there anyway that i can automatically retrieve these information from hundreds of files?
Thanks to all for any help.