ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing from multiple Excel files (https://www.excelbanter.com/excel-discussion-misc-queries/46508-importing-multiple-excel-files.html)

Tired of wasting time

Importing from multiple Excel files
 
Need to save time, I think this must be possible. I have to constantly pull
data from certain cel's, which are contained in any one of our more than 8000
files. I hope this doesn't sound confusing, but:
Is there a way to import data from lets say cel E9, from thousands of files,
and have them all imported into a new excel workbook?

Any advice would be appreciated,

Ryan

Ron de Bruin

Hi

Look on my site for example code
http://www.rondebruin.nl/tips.htm


Maybe Ado is a option for you
http://www.rondebruin.nl/ado.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tired of wasting time" <Tired of wasting wrote in message
...
Need to save time, I think this must be possible. I have to constantly pull
data from certain cel's, which are contained in any one of our more than 8000
files. I hope this doesn't sound confusing, but:
Is there a way to import data from lets say cel E9, from thousands of files,
and have them all imported into a new excel workbook?

Any advice would be appreciated,

Ryan




Ron de Bruin

I add a note about importing only one cell from each workbook to the site

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Hi

Look on my site for example code
http://www.rondebruin.nl/tips.htm


Maybe Ado is a option for you
http://www.rondebruin.nl/ado.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tired of wasting time" <Tired of wasting wrote in message
...
Need to save time, I think this must be possible. I have to constantly pull
data from certain cel's, which are contained in any one of our more than 8000
files. I hope this doesn't sound confusing, but:
Is there a way to import data from lets say cel E9, from thousands of files,
and have them all imported into a new excel workbook?

Any advice would be appreciated,

Ryan







All times are GMT +1. The time now is 02:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com