Shell Function

[jmb0730]

I am trying to start an application by clicking a cmd button. I am using the Shell() function but am receiving an Invalid Call Arguement error. I need to be able to click one of eight different cmd buttons to start one of eight different applications. The applications range from excel spreadsheets to batch files. Thanks for any help!

 

[AGIMA]

Read this.

http://www.tek-tips.com/viewthread.cfm?qid=1063387&page=2

AGIMA - professional web hosting is our business.

AGIMA Computing

http://www.agima.com.au

 

[bjd4jc]

Depending on what the other 6 applications are, you may want to also have a look at the ShellExecute function.

See thread222-919673 for details on how to use this.

The reason I bring this up is because you won't simply be able to open the excel spreadsheet without giving the specific path to excel.exe (which is different for different versions, etc.). So using shell you would have to do something like:

Shell "C:\program files\Microsoft Office\Office 10\Excel.exe MySpreadSheet.xls". Shell execute, you just specifiy the path of the spreadsheet.

 

[jmb0730]

The other 6 applications vary from batches to executables to spreadsheets. The only one I had trouble with was the spreadsheets but I am going to try she shell execute. Thanks

 

[johnwm]

Or you can use the RunDLL32 method:

Shell "RUNDLL32.EXE URL.DLL,FileProtocolHandler " & myfulldocname, vbNormalFocus

You can pass any URL (either filename or website) to that procedure and it will open with the default application

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts