It seems a simple task but tricky one...
I have a .csv file that I need to periodically get imported in Amibroker database. How Can I do that? I have tried below code in Excel VBA. but it does not work.
AB is version 5.5 64 bit. I can switch to 32 bit if required.
Excel is 2007 32 bit.
###############
Sub AmiAsciiImport()
' import the data using appropriate format definition file
Dim Amibroker As Object
Dim filename As String
Set Amibroker = CreateObject("Broker.Application")
filename = "F:\Prakash_Docs\ATS\Mydata.csv"
Call Amibroker.Import(0, filename, "Mydata.Format")
Call Amibroker.RefreshAll
MsgBox "yo Done!"
End Sub
I have a .csv file that I need to periodically get imported in Amibroker database. How Can I do that? I have tried below code in Excel VBA. but it does not work.
AB is version 5.5 64 bit. I can switch to 32 bit if required.
Excel is 2007 32 bit.
###############
Sub AmiAsciiImport()
' import the data using appropriate format definition file
Dim Amibroker As Object
Dim filename As String
Set Amibroker = CreateObject("Broker.Application")
filename = "F:\Prakash_Docs\ATS\Mydata.csv"
Call Amibroker.Import(0, filename, "Mydata.Format")
Call Amibroker.RefreshAll
MsgBox "yo Done!"
End Sub