Use Shell command to open another app maximised

[AndyCotgreave]

HI there,
First post (I defected from Excel-L!) - hello all.

I'm opening another application (Tableau) from within Excel, connecting Tableau directly to the current file. I am building the following string to use in the Shell command:

"C:\Program Files (x86)\Tableau\Tableau 7.0\bin\tableau.exe" "C:\Users\acotgreave\Dropbox\TableauReshaper\test data.xlsx"

When I run this from the command line, Tableau opens maximized. However, when I run the same code through a VBA Shell command, Tableau opens in a minimised state:

    ' construct the command line and execute it
    strCmdLine = Replace(strTableau, "%1", ActiveWorkbook.FullName)
    Shell (strCmdLine & " /max")

Any ideas how I can force the other app to be maximised?

Thanks

[Firefly2012]

Hi

Shell strCmdLine, 3

[AndyCotgreave]

Gosh, that's embarrassing. I've been writing VBA code for getting on 10 years and didn't know Shell had a second parameter.
That's sorted the problem out - thanks very much.
Andy

[snb]

or

Createobject("wscript.shell").run "notepad.exe",3