obtain value from a closed workbook.xls

A

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...
 

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

Need to Keeping Same Display Value on 2 Workbooks 1
excel help please 1
Need help cleaning up a macro that "copies" data from another work 1
Using a Macro from one workbook within another 1
Copy data from workbook 2 to workbook 3 mystery! 2
OFFSET() function with external references 3
cell reference in another workbook 1
Sheets("sheet1").Range command between workbooks 3

Top