excel help please

A

ANtonis

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
Help with selecting all cells in a sheet -- Error 1004 5
Is Excel Threadsafe 13
Copy data from workbook 2 to workbook 3 mystery! 2
obtain value from a closed workbook.xls 1
efficient code to copy/paste 7
loop through and update 0
Need help cleaning up a macro that "copies" data from another work 1

Top