How do i run win shell script?

[edojan]

Hello

Here is the shell script i have (vbs)
how do i run it in a module make function out of it???

Set WshShell = WScript.CreateObject("WScript.Shell")
WScript.Sleep 10
WshShell.AppActivate "Microsoft Office Outlook"
WshShell.SendKeys "{TAB}"
WshShell.SendKeys "{TAB}"
WshShell.SendKeys "{ENTER}"
WshShell.SendKeys "{TAB}"
WshShell.SendKeys "{TAB}"
WshShell.SendKeys "{ENTER}"

Thanks

 

[pbaldy]

What is it you're trying to do? SendKeys is not considered reliable (I don't think you can count on where focus will start in this instance).

 

[edojan]

basically click yes for outlook security window ... but it does work but i have other scripts for other purposes ... just need to know how i either run the vbs file/script from access or integrate into module ...

 

[pbaldy]

Personally I've used ClickYes, but there are other ways:

http://www.mdbmakers.com/forums/showthread.php?t=3147

SendKeys exists in Access, if you wish to try it.

 

[edojan]

but its not just for outlook security so sendkey wont do it....
We have vbs scripts that ftp files over and stuff ...