Executing a VB Script file from VB.net

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J. Kingsley - 30 Jul 2004 08:17 GMT

I am loading XML data into a SQL Server database using SQLXML with bulkload. I use a VB script file to perorm the load with the map schemas and the XML files. To do the load manually, you just double click on the VB script file which lies in a directory on the hard drive. Now I want to execute this file from a VB application or a Windows service. How do I call, reference or execute the file from VB.net?

Reply to this Message

David Williams , VB.NET MVP - 30 Jul 2004 13:25 GMT

You should be able to use Process.Start("SQL.VBS") [Where you replace
"SQL.VBS" with your named .vbs file] to run the script file.

HTH

David

> I am loading XML data into a SQL Server database using SQLXML with
> bulkload. I use a VB script file to perorm the load with the map schemas and
> the XML files. To do the load manually, you just double click on the VB
> script file which lies in a directory on the hard drive. Now I want to
> execute this file from a VB application or a Windows service. How do I call,
> reference or execute the file from VB.net?

Reply to this Message

J. Kingsley - 30 Jul 2004 14:15 GMT

Thanks, it works! A simple piece of code, but you saved me a lot of time.

> You should be able to use Process.Start("SQL.VBS") [Where you replace
> "SQL.VBS" with your named .vbs file] to run the script file.
[quoted text clipped - 9 lines]
> > execute this file from a VB application or a Windows service. How do I call,
> > reference or execute the file from VB.net?

Reply to this Message

Executing a VB Script file from VB.net

Free Magazines