Copy values from closed workbook

[Alpacino]

Sorry I know this has probably been asked about a millions times anyone help with trying to copy values from workbook total sheet1 to workbook
Input sheet2 please

 

[VoG]

VoG: What if it takes 15 seconds to open the workbook?

Could you post the absolute bare-bones that it takes to get a range out of a closed workbook, please?

See the link from my first reply. http://www.rondebruin.nl/ado.htm

I've worked with some pretty big workbooks and I've never had one that took 15 seconds to open.

 

[Glory]

Well mine do.

That link is great, really great. Maybe it will finally help me make some progress with this.