Use data from another workbook

[todtown]

It seems I once knew how to do this. Then again, there's a lot of
things I used to do better than I do now. <g>

My workbook is a form that is populated by calculating data from
another workbook. I'd like the form to get the data from the other
workbook without making that workbook visible. Just reference the data
in memory. The user never sees the other workbook, just the form being
populated.

What did I forget?

tod

 

[dan dungan]

My workbook is a form that is populated by calculating data from

another workbook.

Based on your message, it seems the workbook is already functioning.
Please be more specific with some details as to what is not working.

My experience with linked workbooks is that they need to be open to
set them up, but after that one can view the data without opening the
source.

Dan

 

[todtown]

Basically it's like this. I have one workbook that has only one
worksheet. That worksheet is formatted to look like a form. There is
another workbook with only one worksheet that contains raw data. The
original owner has been using a calculator and other manual processes
to summarize the data in the raw data sheet and then typing the
results into the form and printing it out. I would like for the user
to open only the 'form' workbook and run a macro to summarize the data
from the raw data workbook. Easy enough. However, I don't want the raw
data workbook to be visible. I can use VBA to do the calculating and
filling in the results, etc. I just don't remember how to keep the raw
data 'in memory' and not visible.

tod

 

[dan dungan]

Hi Todd,

If you're using Excel 2000, have you tried data/get external data/new
database query?

Dan