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