Excel - DOS COMMAND using Shell ?

[marco02]

Hi guys,

I would like to run 1 or 2 DOS commands from in my ExcelVBA application.

I red somewhere that:
Shell "COMMAND.COM dos_command_as_a_string"
should do it.

It doesn't seem to work, can somebody help me on this matter? Thanks a lot,

Marco

PS: i want to convert a file from .jpg to .png using IFRANVIEW. My dos commands are gonna be:
- cd ifranview
- i_view32.exe c:\dummy.jpg /convert=c:dummy.png

thks!

 

[CajunCenturion]

I would suggest that since you have multiple DOS commands that you have to execute, that you build a DOS .BAT file which contains all of the DOS commands.

Then from VB

Shell "bat_filename"

Good Luck
------------
Select * from Users where Clue > 0
0 rows returned