![]() |
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 |
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 |
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