Excel VBA Call Shell with quotes in string

Question

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!

Tim Williams · Accepted Answer · 2017-06-02 19:43:25Z

5

In VBA quotes are escaped by doubling them up:

Call Shell("C:\Temp\Zint\zint.exe -d ""1234""",vbNormalFocus)

answered Jun 2, 2017 at 19:43

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Dominik Over a year ago

Thanks! It did not work but i've found the solution... i've spent my whole day solving it... Call Shell("C:\Temp\Zint\zint.exe" & " " & "-d" & Chr(34) & "1234" & Chr(34), vbNormalFocus)

Siddharth Rout Over a year ago

@Dominik you answer is the same as what Tim posted here :)

YowE3K Over a year ago

@SiddharthRout - Maybe getting rid of the space in -d "1234" was required to get it to work, but there certainly is nothing in the question to indicate that it shouldn't be there, so I agree that Tim's answer is better than the OP's self-answer

Dominik · Accepted Answer · 2017-06-02 19:51:14Z

0

The solution is:

Call Shell("C:\Temp\Zint\zint.exe" & " " & "-d" & Chr(34) & "1234" & Chr(34), vbNormalFocus)

answered Jun 2, 2017 at 19:51

Dominik

311 silver badge2 bronze badges

2 Comments

Tim Williams Over a year ago

That's exactly the same as my suggestion (but more complex IMHO) except you now have no space between the -d and "1234"

YowE3K Over a year ago

If getting rid of the space between -d and "1234" was required to get the code to work, please update the question to say something like " When I use this command in the windows command line: C:\Temp\Zint\zint.exe -d "1234" it doesn't work, but C:\Temp\Zint\zint.exe -d"1234" does work "

Collectives™ on Stack Overflow

Excel VBA Call Shell with quotes in string

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related