start external program

[C Williams]

I am using Visual Studio 2003 and trying to use the "Start External
Program" option to start Excel when I run the program. What happens is
that Excel opens and then immediately closes. I know that in the past
it has opened and stayed open, and I am wondering what I have
inadvertently changed and how I can change it back.


Thanks,

-Casey

 

[Chris Calzaretta]

as you stated it in your post when you open excell it should stay open. This
is correct. You are eather closing excel or it is bombing.
are you shelling
shell("excel.exe" filename.xls)
i belive that opens a excel file.

Chris

 

[C Williams]

No, I am not using "shell"--I am trying to use Visual Studio's Start
External Program feature, which should open up a blank excel file.

Excel works just fine when I open it manually (outside of visual studio)

 

[Chris Calzaretta]

I am sorry I have never used that

This is the example in .net for visual basic from the msdn on starting
application exampel
Dim ProcID As Integer
' Start the Calculator application, and store the process id.
ProcID = Shell("CALC.EXE", AppWinStyle.NormalFocus)
' Activate the Calculator application.
AppActivate(ProcID)
SendKeys.SendWait("22")
SendKeys.SendWait("*")
SendKeys.SendWait("44")
SendKeys.SendWait("=")