getting a value from a closed workbook then pasting it on active wrkbk

[denvernuggets15]

can someone please show me how to:
Get (copy) a value from range("a1") of a closed workbook, then pasting the value on range("c5") of the active workbook. Then if the value = 12345 then instead of showing 12345, excel will immediately replace it with "i love tennis".

I'm a beginner at excel vba programming, so i'd reallpy appreciate the help!
Thanks!

[jraj1106]

Hi

Try this:

Book1.xlsm

Regards...

[denvernuggets15]

Thank you very much! It works perfect!
Just one more thing.... how could you make this macro run continuously? Like if range("a1") of the second workbook is 12345 then the range("c5") of the first wrkbk will immediately show "i love tennis". In other words, the macro will run without you clicking Run.

again, Thanks!

[denvernuggets15]

how to you make the value from a1 show up in c5, even if it's not 12345? (cuz now it only shows it when it =12345)?
Thanks!

[jraj1106]

Hello,

Check this out:

copy data from a closed sheet code.xlsm


Regards...