Copying from a closed workbook

**Dave H9** · 06-14-2011, 04:16 PM

I have a large project I am trying to speed up. First task is once modified, to use this code which I found from web searching -

Please Login or Register  to view this content.

I can get this to retrieve a single cell of data but need it to do the following -
From a module in a destination workbook retrieve an entire column from a source workbook. For example column C in source workbook "data.xls, sheet3" is copied in it's entirety to column A in destination workbook "Summary.xls, sheet4".

Any assistance is (as always) greatly appreciated.

Many thanks

Dave H

**realniceguy5000** · 06-14-2011, 04:58 PM

Here is something I picked up on a google, See if you can modify for your needs.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

.
Post back any issues, I ran some tests and it seemed to work well...

...

**Dave H9** · 06-15-2011, 03:10 AM

Fantastic Mike thank you very much, this works exactly as I need.

**snb** · 06-15-2011, 04:27 AM

or

Please Login or Register  to view this content.

**Dave H9** · 06-15-2011, 04:31 AM

Many thanks snb, I'll give that method a try also.

**snb** · 06-15-2011, 04:55 AM

Another alternative using a querytable:

Please Login or Register  to view this content.

In English

Please Login or Register  to view this content.

Adapt:
- E:\OF\adressen 001.xls
- Blad1$

**Dave H9** · 06-15-2011, 05:02 AM

Thanks again snb,

Can either of these be used in reverse ie write to closed workbook? I have just started a new thread on this topic here. I would be very grateful if you could give some input.

Dave H