Problems with reading stuff from closed files

[bluesdata]

Hi,
I would like to create a single excel file, which is composed by fragments of different (closed) excel fies (it should take some data from the files).
Is that possible?
Thanks

[antoka05]

Try to see this URL:
http://www.rondebruin.nl/copy7.htm

Regards,
Antonio

[bluesdata2]

Hello,

Yesterday, I asked how to read stuff from closed files.
Someone kindly suggested the following link:

http://www.rondebruin.nl/copy7.htm
I tried that and it worked, the problem is that it's too slow.
In the main sub, it uses DoEvents (which yields the processor), which is what I believe that causes it to be slow.
1) Is it necessary to use the wait operation?
2) Do you know faster / other ways to read data from (many) other xls files?

Thanks a lot!

[bluesdata3]

Hello,

Yesterday, I asked how to read stuff from closed files.
Someone kindly suggested the following link:

http://www.rondebruin.nl/copy7.htm
I tried that and it worked, the problem is that it's too slow.
In the main sub, it uses DoEvents (which yields the processor), which is what I believe that causes it to be slow.
1) Is it necessary to use the wait operation?
2) Do you know faster / other ways to read data from (many) other xls files?

Thanks a lot!

[Leith Ross]

Hello bluesdata3,

It would help to know how slow is slow? There are other methods of data retrieval from a closed workbook, but selecting the best method depends on several factors. It would be best for you to post your workbook so a workable solution can be suggested.

Sincerely,
Leith Ross

[jindon]

Let's see if this is any faster

Please Login or Register  to view this content.

[bluesdata4]

one more thing, is it possible just to put the 'wait' section in a comment?
thanks

[jindon]

How about

Please Login or Register  to view this content.

Why ?
What you are doing is just reading the block of range into the same size of the range.
No need to use Array Formula. and Do Events

[jindon]

You code is using FormulaArray, which doesn't need to be an array formula.
Array formula needs more time to calculate.

Show me the code that you are calling this sub routine.

[jindon]

oops missed a "."

Please Login or Register  to view this content.

[VBA Noob]

Please use forum rules below and then stop spamming the same question under these user names

Also note rules 5 about wrapping code. If you ignore the rules your threads may be locked or even deleted

bluesdata, bluesdata1, bluesdata2, bluesdata3, bluesdata4

VBA Noob