Running .vbs file from MATLAB

10 次查看（过去 30 天）

Jason Allnutt 2016-2-14

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/268099-running-vbs-file-from-matlab

评论： Jason Allnutt 2016-2-18

I have a .vbs file on my computer that accesses a database and creates a text file of the info in the database. How do i have MATLAB tell this file to run? I tried the open command and all it did was open the script in a MATLAB editor.

Also, I have attempted accessing the database with the Database Toolbox but that has given me issues. I am attempting running the .vbs file as a work around for the time being.

-Jason

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Guillaume 2016-2-14

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/268099-running-vbs-file-from-matlab#answer_209803

编辑：Guillaume 2016-2-14

在 MATLAB Online 中打开

Possibly:

system(sprintf('cscript.exe "%s"', 'c:\full\path\to\your\script');

Considering that vbs scripts tend to just contain calls to activex (COM) objects which matlab can also do, you may as well rewrite the script in matlab. It's more maintainable in the long run.

5 个评论
显示 3更早的评论隐藏 3更早的评论

Jason Allnutt 2016-2-18

Hey Guillaume,

I could use some help using the activex controls to connect to my SQL sever. When i run the second command I get "Error using COM.ADODB_Connection/Open".

I'm 99% sure i have the correct DSN, UID, PWD and Database name. But I have limited knowledge of activex controls, so possibly you could point me in the direction to figure get some more knowledge on this. Anything would be most appreciated.

-Jason

Jason Allnutt 2016-2-18

I figured it out. I needed to set the provider and rename a couple of the fields.

However, I am having trouble finding the equivalent to the "fetch" command in the DB toolbox. I have my Recordset.Open exectuing. But now, to save the data i'm capturing to a variable, I'm unsure.

-Jason

请先登录，再进行评论。