Update cell links between 2 excel file without opening source file

F

ferry

As I read from these forums,anybody could help coding for me. My proble
maybe solved by merging some threads as follows :

http://www.excelforum.com/excel-prog...eadsheets.html
http://www.excelforum.com/excel-prog...-workbook.html
http://www.excelforum.com/excel-gene...ime-close.html.

Questions and problems:

I have Test1.xlsx & Test2.xlsx file Test1 file get every cell's dat
from Test2 by putting 'Test2'!cell address' in Test1 cells. Data update
every seconds. I keep open,close &open to get Test1 updated. Is there
way to get Test1 updated without opening the Test2.xlsx file ? If "NO
,I thought the second & third thread above could be solving this.

To open,close and open the Test2.xlsx, I just need to open it for
seconds(minimized) and close it for 10 seconds & open again for
seconds and so on. Is somebody could code this? I'm newbie in VBA, eve
didn't know how to put the code and run/stop the VBA when it run.Pleas
give some clue. Thanks for kindness
 

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

Top