Copy data from MS Excel Binary Workbook without opening it & paste them in time order

[WonderlandBOS]

Hi All,

This is my first question. One of my work is using VBA to copy certain number and date from each binary workbooks (there are tons of workbooks) without opening them. And paste them into one worksheet from a new workbook in time order.


How should I accomplish that?

Thanks,
WonderlandBOS

 

[alansidman]

These links may be helpful

VBA Express : Excel - Extract Data From Closed Workbooks

http://www.mrexcel.com/forum/excel-...pulling-data-closed-workbook-w-o-opening.html