|
PureBytes Links
Trading Reference Links
|
Yuki,
Your Excel file can be saved as a normal Excel file and the macro can be
modified to automatically SaveAs a .csv before importing.
Terry
--
> 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
>
>
>
> Check AmiBroker web page at:
> http://www.amibroker.com/
>
> Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
> <http://us.ard.yahoo.com/SIG=129fsr5se/M=298184.5285298.6392945.3001176/D=grou
> ps/S=1705632198:HM/EXP=1092473886/A=2164331/R=0/SIG=11eaelai9/*http://www.netf
> lix.com/Default?mqso=60183351>
>
>
> 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
> <mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
> *
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
--
Terry
[Non-text portions of this message have been removed]
------------------------ 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/
|