Re: Help me with shell execute
Quote:
Originally Posted by
WoF
You simply mixed up the number of double-quotes.
try to print the string.
Code:
debug.print "mspaint " & """ & imgFname & """
and see what you get. You will find imgFname printet literally because it is within valid quotes. It must be
Code:
lngerr=Shell("mspaint """ & imgFname & """")
'or
lngerr=Shell("mspaint " & chr$(34) & imgFname & chr$(34))
Code:
Public Function execute_file_in_paint(imgFname As String)
lngErr = Shell("mspaint " & Chr$(34) & imgFname & Chr$(34))
End Function
Worked Charm !!!
Let me rate you post guys, really helpfull all your posts!