Plugging data from non-open Workbooks

H

Herbert Chan

Hello,

I have a number of databases stored on Excel Workbooks and I want to create
another workbook to get information from those databases. I will make
reference to a number of the databases with the following:

COUNTIF("worksheet name followed by filename", "=blablabla")

but I don't want to open them as they are like each 5Mb in size and I have
to refer like 10 of them on a worksheet.

I've tried opening one of the database and then reference it by
point-and-clicking and then closing it. The formula works fine when the file
is open. When it's closed and I try updating the worksheet by pressing F9,
the cell changes to #VALUE. Why's that?

Anyone can help me? I'm using Excel97.

Herbert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recording Data Into Closed Workbook! 0
Plugging data from non-open Workbooks 4
copying a style from one worksheet to another in the same workbook 1
How can I open an Excel Workbook from Outlook macro and activate that workbook? 1
Copy worksheet from one book to open workbook 1
Append data from newly created worksheets to another sheet in thesame workbook 0
VBA compile error 1
Macro VBA coding, Copying content from one workbook to a new one 0

Top