Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Running apps from inside excel

Greetings,
Thanks in advance for taking the time to read this ...
With the following code, a powerpoint .pps slideshow will
open, run , close and return to excel, no problem:
Sub RunPowerpointShow()
Dim pwp As Object
Set pwp = CreateObject("PowerPoint.Application")
pwp.Visible = True
Set pwfile = pwp.presentations.Open
(FileName:="P:\test.pps")
pwfile.SlideShowSettings.Run
pwp.Quit
End Sub
I would like to be able to run Lotus ScreenCam files in a
similar manner. These can be created as .exe files which
do not require the user to have any ScreenCam software
installed. Could anyone advise on code required to run
ScreenCam file "P:\test.exe"
TIA
David
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 391
Default Running apps from inside excel

in a simple way:

Shell "P:\test.exe"

read up on the Sell command. For more serious work, look
into the VBScript shell object...
Set oShell = CreateObject("WScript.Shell")
With this you can check whether the shell is running etc

Patrick Molloy
Microsoft Excel MVP



-----Original Message-----
Greetings,
Thanks in advance for taking the time to read this ...
With the following code, a powerpoint .pps slideshow

will
open, run , close and return to excel, no problem:
Sub RunPowerpointShow()
Dim pwp As Object
Set pwp = CreateObject("PowerPoint.Application")
pwp.Visible = True
Set pwfile = pwp.presentations.Open
(FileName:="P:\test.pps")
pwfile.SlideShowSettings.Run
pwp.Quit
End Sub
I would like to be able to run Lotus ScreenCam files in

a
similar manner. These can be created as .exe files which
do not require the user to have any ScreenCam software
installed. Could anyone advise on code required to run
ScreenCam file "P:\test.exe"
TIA
David
.

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
Help - Alt-E hotkey does not work in MSOffice apps, no prob in other apps Bob Newheart Excel Discussion (Misc queries) 4 July 28th 08 03:57 PM
Event Macro running another macro inside K1KKKA Excel Discussion (Misc queries) 1 December 20th 06 08:21 PM
Active cell blinks for no reason while running inside of Citrix XP Ed Miller Excel Worksheet Functions 1 January 25th 05 04:53 PM
Handling Excel Apps? andy. Excel Programming 1 July 25th 03 04:51 AM
Switching to other apps while running macros in excel 97 Jon Peltier[_3_] Excel Programming 2 July 11th 03 10:49 PM


All times are GMT +1. The time now is 10:19 AM.

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"