Launch VBS from VBA
i do one of these
a prior macro introduces the "connected " to display that i was able to net
use to the workstation
retval = Shell("cmd /c C:\scriptname.vbs " & Replace(c.Value, "connected ",
""), vbMaximizedFocus)
"Cajeto 63" wrote:
Hello,
I'm trying to launch a VBS from excel using the code below:
Dim Retval
RetVal = Shell("cmd / u:\windowsu:\Formation\DataSet
Vision\VBscriptXL_Vision\ImportDonnéesTest.vbs")
but it does not work although the vbs works perfectly when launched "by hand"
Instead of running the script it opens a cmd windows giving the following
message:
" CMD.EXE was started with the path "\\myserver\myname\my documents" as the
current directory. UNC paths are not supported. Defaulting to windows
directory."
Any help to solve this issue would be very highly appreciated.
Thank you.
--
Regards, Cajeto 63.
|