Reading information from a closed workbook

Hi

I need to run a VBA program that reads information from a second excel workbook.

Is it possible to extract this information while the second workbook is closed?

Thanks

you'll find the excel tips a wonderful source of information.

the best answer would depend a lot on the specifics. However, the fastest
way is to put a linking formula in a worksheet and retrieve the information

ActiveCell.Formula = "='C:\My Folder\[Myfile.xls]Sheet1'!A1"
' No replace the formula with the value returned
ActiveCell.Formula = ActiveCell.Value

you can do multiple cells this way with one command

with ActiveCell.Resize(50,10)
.Formula = "='C:\My Folder\[Myfile.xls]Sheet1'!A1"
.Formula = .Value
End with

If the data is organized like a Database, you can use ADO


http://www.erlandsendata.no/english/...php?t=envbadac

--
Regards,
Tom Ogilvy



"yhockman1" wrote:

>
> Hi
>
> I need to run a VBA program that reads information from a second excel
> workbook.
>
> Is it possible to extract this information while the second workbook is
> closed?
>
> Thanks
>
>
> --
> yhockman1
> ------------------------------------------------------------------------
> yhockman1's Profile: http://www.excelforum.com/member.php...o&userid=32474
> View this thread: http://www.excelforum.com/showthread...hreadid=522603
>
>