Re[2]: [amibroker] Auto-refresh displayed csv file

[Herman <psytek@xxxxxxxx>]

Title: Re[2]: [amibroker] Auto-refresh displayed csv file

Thanks Y, i have been doing exactly that but am stuck with the last step.

1) how do i make excel refresh the data automatically, i.e. how do i use the 'refresh method' of excel?

2) how do i prevent Excel from locking the file so that afl can modify it? Right now whenever i load the file it locks it.

thanks,

herman

Tuesday, March 24, 2009, 11:51:37 AM, you wrote:

>

Hi Herman,   Write your data from AFL to a csv file.  Create an Excel workbook.  In on of the worksheets import data from the text file. Create your charts etc. based on the data area of the import worksheet on a new worksheet. Create a  button on the new that executes the data refresh method of Excel (VBA).   Regards,   Y From: Herman  Sent: Tuesday, March 24, 2009 9:21 AM To: AmiBroker User Group  Subject: [amibroker] Auto-refresh displayed csv file I want to display system status/performance in real-time, preferably in Excel, and display a table and some some charts that refresh automatically. It seems that whenever i load data in Excel it locks the file and i can no longer modify it. Also it doesn't refresh automatically to display real-time info. Any suggestions will be much appreciated! herman

__._,_.___

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___