Hi again everyone ...
The code thread below was originally suggested by our respected Mr Brian to solve part of my VBA problem in short-cutting the hyperlink "alert" messages.
But now I'm in the midst of trying to run my Excel VB from a portable device i.e a CD on a thumbdrive. And I have failed to get it running the same way as when it was running from my C drive though the Dos batch file is still being placed in the C drive.
I've tried to read the syntax in Dos Command Help file, but I find it a bit overwhelming for me to understand.
The piece of code is as below:
RSP = Shell(Environ$("COMSPEC") & " /c c:\myfolder\batch file\test.bat", vbNormalFocus)
Can anyone show me the light where have I gone wrong in trying to migrate my VB application from the C drive to a portable device i.e in running the above code.
I'm humbly appreciate all responds and suggestions from all of you.
Thank you.
- Mang -
The code thread below was originally suggested by our respected Mr Brian to solve part of my VBA problem in short-cutting the hyperlink "alert" messages.
But now I'm in the midst of trying to run my Excel VB from a portable device i.e a CD on a thumbdrive. And I have failed to get it running the same way as when it was running from my C drive though the Dos batch file is still being placed in the C drive.
I've tried to read the syntax in Dos Command Help file, but I find it a bit overwhelming for me to understand.
The piece of code is as below:
RSP = Shell(Environ$("COMSPEC") & " /c c:\myfolder\batch file\test.bat", vbNormalFocus)
Can anyone show me the light where have I gone wrong in trying to migrate my VB application from the C drive to a portable device i.e in running the above code.
I'm humbly appreciate all responds and suggestions from all of you.
Thank you.
- Mang -