|
Hi Hermen,
I use the latest Office 12 suite w/SP1. The
connection property window has a checkbox to do refresh in every x minutes.
It does not lock the file. I could edit it w notepad+
I don't do it through ODBC! Directly from
Excel.
the line of code you need to call if want to do it
manually:
ActiveWorkbook.Connections("test").Refresh
(Replace test w/ your conn name)
Y
Sent: Tuesday, March 24, 2009 10:16 PM
Subject: 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/
![]()
__,_._,___
|