Hi there,

I want to save forex currency data into excel sheet. Forex refreshes
the data every 15 seconds. How to save all data without overwrite the
old one. Thanks in advance.

YJL


--
YJL
------------------------------------------------------------------------
YJL's Profile: http://www.excelforum.com/member.php...o&userid=28693
View this thread: http://www.excelforum.com/showthread...hreadid=490703

Hi

Record a macro, "open a new sheet" then copy forex and paste as value
on new sheet, and save" then stop recording Macro.

Your Forex on the main sheet will still update , but the rest of the
info on the new sheets will have it original value at the time of
issue. Please notethat you have to run macro in order to copy and paste
the data.

thiem


--
Thiem
------------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=490703

any idea to trigger macro automatically in a time series same as data
update?

yjl


--
YJL
------------------------------------------------------------------------
YJL's Profile: http://www.excelforum.com/member.php...o&userid=28693
View this thread: http://www.excelforum.com/showthread...hreadid=490703