|
PureBytes Links
Trading Reference Links
|
Hi Curt,
So many light years are you ahead of me, that I wouldn't even know
what to do with this. ^^_^^
Let me ask you a couple of questions, if I might. The file I'm
saving right now is .csv format. AB imports this just fine, but
unfortunately, there are some formatting tools I'd like to use on the
file (for example, conditional formatting to make sure the H is not <
O or L or C), but all this formatting, including locking cells, which
would be very nice, is lost when saving to .csv format. So, before
we go any deeper, are there any other formats that AB can import,
that can also contain some of these other Excel formatting tools?
Yuki
Friday, August 13, 2004, 4:30:37 PM, you wrote:
c> here is an excel macro that imports to ab. this is set up to
c> import all files in the directory so if you only want one file you
c> will have to remove the loop and change the path.
c> bw
c> curt
c> Sub IMPORT_TO_AB()
c> Set oAB = CreateObject("Broker.Application")
c> sPath = "D:\AMIBROKER\IntradayData\"
c> ChDir "D:\AMIBROKER\IntradayData\"
c> Tic = Dir(sPath)
c> If Tic <> "" Then
c> Do Until Tic = ""
c> FileName = "D:\AMIBROKER\IntradayData\" & Tic
c> oAB.Import 0, FileName, "Custom5.format"
c> Tic = Dir '(sPath)
c> Loop
c> End If
c> oAB.RefreshAll
c> 'Application.Quit
c> End Sub
c> Check AmiBroker web page at:
c> http://www.amibroker.com/
c> Check group FAQ at:
c> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
c> Yahoo! Groups Links
Best,
Yuki
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/GHeqlB/TM
--------------------------------------------------------------------~->
Check AmiBroker web page at:
http://www.amibroker.com/
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
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:
http://docs.yahoo.com/info/terms/
|