View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Striker Striker is offline
external usenet poster
 
Posts: 55
Default Open another program

Thanks Tom, I'll give this a try today.

"Tom Ogilvy" wrote in message
...

. . .
shell "C:\st.exe"
for each bk in workbooks
if bk.Name < thisworkbook.Name then
bk.close Savechanges:=False
end if
Next

Thisworkbook.Close Savechanges:=False
End Sub

--
Regards,
Tom Ogilvy


"Striker" wrote:

How can I open another program from inside excel? Say I have an
executable
in the root of C called st.exe.
C:\ST.Exe. If this is called I want to close excel WITHOUT saving the
changes.

Thanks for your help.