#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Shell ?


I want to open an app which has a shortcut path similar to


"C:\Programe Files\Temp\Temp.exe" "C:\Programes\Temp\Temp2.ws"

However Shell does not like this


?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=561050

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default Shell ?

Sub Macro1()
x = Shell("cmd.exe /c C:\Programes\Temp\Temp2.ws", 1)
End Sub

By using cmd.exe you do not have to start the application. cmd knows which
application to start to process Temps.ws
--
Gary's Student


"ceemo" wrote:


I want to open an app which has a shortcut path similar to


"C:\Programe Files\Temp\Temp.exe" "C:\Programes\Temp\Temp2.ws"

However Shell does not like this


?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=561050


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default Shell ?

Try

Shell "C:\Programe Files\Temp\Temp.exe C:\Programes\Temp\Temp2.ws",1


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ceemo" wrote in
message ...

I want to open an app which has a shortcut path similar to


"C:\Programe Files\Temp\Temp.exe" "C:\Programes\Temp\Temp2.ws"

However Shell does not like this


?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:

http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=561050



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Shell ?


thanks guys i have tried both of these but couldnt get either to work

--
ceem
-----------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...fo&userid=1065
View this thread: http://www.excelforum.com/showthread.php?threadid=56105

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shell function Phil1982 Excel Programming 2 March 16th 06 12:39 AM
Shell & VBA Vikxcel[_7_] Excel Programming 1 January 5th 06 04:02 AM
Shell Stuart[_20_] Excel Programming 1 February 17th 05 01:50 AM
VBE COM Add-in Shell R Avery Excel Programming 1 August 12th 04 02:55 PM
Shell Joseph[_12_] Excel Programming 1 February 1st 04 04:33 AM


All times are GMT +1. The time now is 08:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"