Reference Application API via Matlab

1 Ansicht (letzte 30 Tage)
Brian
Brian am 28 Mär. 2012
I have some VBA code that references a vendor's API in Excel. I am no longer running the job in Excel since I can pull all the data into Matlab and do my analysis much easier. I do still need to reference the API for uploading some information back to the system. The API is referencing a .dll on my local drive. I'm wondering if someone can help me translate this into Matlab code.
Here's an example of my VBA code
Sub UploadInfo()
Dim varResult As Variant
Dim FDSAPI As Object
Set FDSAPI = CreateObject("factset.factset_api")
varResult = FDSAPI.RunApplication("Data Central", _
"COMMAND=Upload", _
"PC_DATABASE = C:\MyFile.xls ", _
"DESCRIPTOR= Client:/Factor/SharesN", _
"ONLINE_DATABASE= Client:Factor/DBS/MyDB.ofdb", _
"MODE = Overwrite_Date", _
"BATCH = True")
Set varResult = Nothing
End Sub
Thanks a lot, Brian
  1 Kommentar
Brian
Brian am 10 Apr. 2012
Just wanted to bump this question. Does anyone know how to either reference an API via Matlab or simulate VBA code with Matlab?

Melden Sie sich an, um zu kommentieren.

Antworten (1)

Jacob Halbrooks
Jacob Halbrooks am 10 Apr. 2012
MATLAB has an API for COM objects that you might try. See Using COM Objects in the doc. In particular, you can probably use ACTXSERVER to instantiate an object for your DLL.

Kategorien

Mehr zu Use COM Objects in MATLAB finden Sie in Help Center und File Exchange

Produkte

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by