Reputation: 31
I don't really know how to deal with my problem. So what i want is:
Call Shell("C:\Temp\Zint\zint.exe -d "1234"",vbNormalFocus)
I use this command in the windows command line: C:\Temp\Zint\zint.exe -d "1234"
It works only when the numbers are given between quotes.
I was unable to deal with the quotes, so please be so kinde to explain me how should i use them.
Thanks!
Upvotes: 3
Views: 3530
Reputation: 31
The solution is:
Call Shell("C:\Temp\Zint\zint.exe" & " " & "-d" & Chr(34) & "1234" & Chr(34), vbNormalFocus)
Upvotes: 0
Reputation: 166980
In VBA quotes are escaped by doubling them up:
Call Shell("C:\Temp\Zint\zint.exe -d ""1234""",vbNormalFocus)
Upvotes: 5