shell command not working

[Farouq Din]

Hi all,

I have this shell syntax and its higlighted in red in vba editor. I
don't think i got it fully right. Could someone take a look for me

Shell("c:\program files\IrfanView\i_view32.exe" "c:\*.tif /convert=
d:\temp\*.jpg")
cheers

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Lyle Fairfield]

Farouq Din wrote:

Hi all,

I have this shell syntax and its higlighted in red in vba editor. I
don't think i got it fully right. Could someone take a look for me

Shell("c:\program files\IrfanView\i_view32.exe" "c:\*.tif /convert=
d:\temp\*.jpg")

Perhaps ...

Shell("c:\program files\IrfanView\i_view32.exe c:\*.tif
/convert=d:\temp\*.jpg")

or

Shell "c:\program files\IrfanView\i_view32.exe c:\*.tif
/convert=d:\temp\*.jpg"

[Tom van Stiphout]

On 21 Feb 2005 09:26:23 -0600, Farouq Din <fa*******@hotmail.com>
wrote:

Shell expects a single string. You are giving it two.
You were probably trying to wrap a path with special chars (such as
space) with double-quotes. It's probably easier to concatenate with
Chr$(34) instead:
strCommandLine = Chr$(34) & "c:\program files\IrfanView\i_view32.exe"
& Chr$(34)
etcetera
Shell strCommandLine

-Tom.

Hi all,

I have this shell syntax and its higlighted in red in vba editor. I
don't think i got it fully right. Could someone take a look for me

Shell("c:\program files\IrfanView\i_view32.exe" "c:\*.tif /convert=
d:\temp\*.jpg")
cheers

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!