Reference Application API via Matlab

Question

Brian 2012-3-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/33746-reference-application-api-via-matlab

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Brian 2012-4-10

Just wanted to bump this question. Does anyone know how to either reference an API via Matlab or simulate VBA code with Matlab?

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jacob Halbrooks 2012-4-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/33746-reference-application-api-via-matlab#answer_43915

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.