obtain value from a closed workbook.xls

[Antonis]

Hello,

I am new to visual basic and I guess that what I am asking can be a
very easy thing to do but not for me.

I am trying to get the value of the cell of a closed workbook2.xls
inside an activated workbook1. But I cannot do that unless workbook2
is also running (inactivated).

I want to get this value though without having to open workbook2. If
thats impossible can I open workbook2 just by typing some code inside
workbook1?

The command I am using at the moment is

Range("A1").Value = Workbooks("WorkBook2.xls").Worksheets("Sheet1").Range("A1").Value

I would really appreciate any ideas you offer me thank you very
much...

 

[Jake Marx]

See reply to earlier post.