RE: [amibroker] Auto-updating Excel from AmiBroker

["dingo" <dingo@xxxxxxxxxxxx>]

<FONT face=Arial 
color=#0000ff size=2>Here's a simple trick:  write a small macro in XL to 
copy (using another name/location of course) the file emitted from AB. Then use 
that file.  That way AB can go on its way without worrying about XL 
glomming onto the file.
<FONT face=Arial 
color=#0000ff size=2> 
<FONT face=Arial 
color=#0000ff size=2>d

  
  
  From: Herman van den Bergen 
  [mailto:psytek@xxxxxxxx] Sent: Tuesday, March 23, 2004 8:11 
  AMTo: AmiBroker YahooGroupsSubject: [amibroker] 
  Auto-updating Excel from AmiBroker
  
  Has anybody been 
  able to update an Excel worksheet automatically from 
  AmiBroker?
  <SPAN 
  class=656060513-23032004> 
  I would like to 
  keep trading records in Excel and would like the Worksheet to automatically 
  refresh from a text file generated by AmiBroker whenever the text file 
  changes. This was discussed some time ago but at the time there was no 
  solution.
  <SPAN 
  class=656060513-23032004> 
  The above 
  mechanism makes it much easier to maintain records when trading portfolios as 
  well as would allow us to automate report analysis in the 
  AA.
  <SPAN 
  class=656060513-23032004> 
  TIA for an 
  solutions you may have. Perhaps a major problem would be that Excel locks 
  files when in use?
  <SPAN 
  class=656060513-23032004> 
  best 
  regards,
  <SPAN 
  class=656060513-23032004>herman.Send BUG 
  REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to 
  suggest@xxxxxxxxxxxxx-----------------------------------------Post 
  AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A 
  href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check 
  group FAQ at: <A 
  href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
  


Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html








Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/amibroker/ 
To unsubscribe from this group, send an email to:amibroker-unsubscribe@xxxxxxxxxxxxxxx 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.