Call a VBScript from within Access

[bmclean2]

What needs to be done in order to run an existing .wsf script when a button/command is selected from a form in Access? Can this be done?

Example:
I have an existing vbscript that performs a search on a file server and dumps the results into a csv file. I then open the access database, and run a function i've created to open the text file, and import into a table.

I would like to be able to do this all from within access without having to manually run the vbscript file.

Thanks..

 

[PHV]

A starting point:
CreateObject("WScript.Shell").Run "\path\to\script.wsf", 3, True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bmclean2]

Thank you...I was able to get the script to run successfully using the following code:

Set sh = CreateObject("WScript.Shell")
rc = sh.Run("c:\temp\query.wsf", 1, True)