Using shell execute from Visual Basic
How can I use the function Shell Execute in Visual Basic Code. I am running MsAccess. I want to use the Shell execute command ro run sqlloader command which loads data into an Oracle table. Would benice to have an example of this.
/Roland
Software/Hardware used:
Software/Hardware used:
ASKED:
May 1, 2008 5:34 AM
UPDATED:
May 1, 2008 1:33 PM
Answer Wiki:
In general, you can run Shell commands with code like:
<pre>' Assume a string called shellCommand
Dim wshShell as Object
Set aWshShell = WScript.CreateObject("WScript.Shell")
aWshShell.Exec shellCommand</pre>
You can more information on Exec at <a href="http://msdn.microsoft.com/en-us/library/ateytk4a(VS.85).aspx">Microsoft's WshShell.Exec reference for VBA</a>.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
