Get a value from another workbook

How do you copy a value from another workbook using VBA code? For example copy range("D4") of workbook2, and pasting the value on Range("J18") of the active workbook.
Also, is it possible to have workbook2 be closed, or not show it?

Thanks in advance!

For the first part of your question perhaps a macro like this?

Please Login or Register  to view this content.

Yes it's also possible to read data from a closed workook. Depending of how much data you may whis to read it can sometimes be faster to open the workbook, read data and close the workbook.

See link for reading data from closed workbook.
http://spreadsheetpage.com/index.php..._a_closed_file

Alf

Thank you! How could you write an if function saying If cell E4 of workbook2 has a value, then cell D5 will be copied and pasted on cell J18 of the active workbook?
The macro will only copy cell D5 of workbook2 If cell E4 has a certain value.

Thanks again!

Like this probably:

Please Login or Register  to view this content.

Alf

Thank you again alf!
Is there anyway that workbook2 be closed while the macro is running? (I'm running this macro from the currently active workbook).

Many Thanks!

Is there anyway that workbook2 be closed while the macro is running?

Yes there is. Check the link I added in post #2 where this technique is described.

Alf