Opening multiple programs in VBA

[Guest]

I am trying to open two different program files, one after the other, in VBA
within an Excel macro.

This is what I have so far:

Shell ("C:\Program Files\Quick3270\Quick3270.exe" "C:\Program
Files\Quick3270\ IBM System.ecf")

This does not work, though. Is it because one of these files is an ecf?
Thanks

 

[Chip Pearson]

The Shell command is passing the second program's name as an
input to the first program. Use two Shell commands, one for each
program.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...

 

[Guest]

Chip, I have tried this, but it still won't open. How would you write it?
Shell (C:\ ...)
Shell (C:\ ...)

Or, is there another way? Thanks

 

[Chip Pearson]

What is the second file? An executable program?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

message

 

[Guest]

As best I can tell it is some type of configuration file. Basically, the
..exe files opens, then the other file configures it somehow.

 

[Dave Peterson]

If you put it all inside one set of quotes, does it work:

Shell """C:\..\Quick3270.exe"" ""C:\..\IBM System.ecf"""

I shrunk the path just to make it fit on one line in the post. You'll have to
correct this before you test.

And it looks like you have an extra space in " IBM system.ecf"

 

[Guest]

Unfortunately the double set of quotes did not work. Do you know if there is
another command I could use instead of Shell? Thanks.

 

[Dave Peterson]

There's an API call that you could use, but I think you'll have the same
trouble.

You may want to post what you tried.