• 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.

Reading excel Files without opening it

veronica.mam

New Member
Hi, i have huge data in the excels which i need to process. All the processing is done with the help of Macro,which is working fine. But it takes a lot of time for the macro to open the excel file (list of files) as the data is huge. Is there a way by which i can read the data in the workbook without the need to open it !!!! Thank you for helping :)
 

Luke M

Excel Ninja
Maybe this will help?

http://www.rondebruin.nl/ado.htm


Ron has several excellent articles on copying/merging data as well.

http://www.rondebruin.nl/tips.htm
 

veronica.mam

New Member
Thanks Luke. I have written a similar code for this but my concern is that:


"Set mybook = Workbooks.Open(MyPath & MyFiles(Fnum))" ... this call, physically opens the excel file. For me it takes a lot of time as there is huge amount of data in the file to be read. I was wondering if I could read the data from the file without the need to "OPEN" it so that the performance of my macro is enhanced. Hope I have made myself clear !!!
 

kchiba

Active Member
Hi Veronica,


You can use the Consolidate function, if you only want to get data from one file, ADD a dummy file with no data.


Cheers

Kanti
 

veronica.mam

New Member
HI Kanti,


It is not just consolidation of hte data from different workbooks but it also needs processing it like filtering, separating data in different columns based on tabs and spaces, calculation etc...

So, I wanted to know whether there is a way to read the files without the need to physically open it in the system !!!


THanks

Veronica
 

Luke M

Excel Ninja
Veronica,

I'm not sure where you're seeing that line of code. The first link is written specifically about not having to open the workbook, so I'm a little confused. I did find this other page of Ron's that uses a different technique.

http://www.rondebruin.nl/copy7.htm
 

kchiba

Active Member
Hi Veronica,


If the aim is to get the data without opening the Source workbook, then the Consolidation function will get the data into the target spreadsheet and therafter you can manipulate any which way you want.
 

kchiba

Active Member
Hi Veronica,


Please give me an example of what you want to do, I have many utilities to extract data.


kanti
 
Top