Hello,

Excel 2000

In an effort to speed up a report generating Excel file, I am experimenting
with NOT opening the Excel database file which is huge and takes 20 seconds
to open.

I need vb code that will get data from specified cells in an unopened Excel
file (database) and then write to an array (created in vb) in my current
file. I want to do this entirely in vb (I don't want to write a formula to
a range and then put in an array). Is this possible? Any examples?

Thanks, you guys are a great resource.

Dave