Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Start Excel when a Third Party Application is Started

Posted on 2009-05-12
4
Medium Priority
?
451 Views
Last Modified: 2013-12-17
Is there a way to start Excel 2007 when another application (third party) is started or launched?

 We work in a Lab environment and need to record the utilization  of certain high-end pieces of equipment (who is using it) and then ultimately be able to bill the users on a per use basis.  After each use, the application is shut down by the researcher, but windows is still running, so I can't just capture who is logged in.

The surest way to record each user is to start Excel when the specific application is launched, in full screen mode, have the user fill in a couple pieces of information, click Enter or Submit, and then Excel closes or minimizes.  They are able to then proceed using the application.  This code will be used on several machines and each application is different.

Thanks,

Ron

0
Comment
Question by:Cook09
  • 2
  • 2
4 Comments
 
LVL 17

Expert Comment

by:Shanmuga Sundaram
ID: 24366320
Better you can try using vbscript or bat file. Whenever the user loads the batch file, you can write code to load your third party application and at the same time you can load the excel file.
0
 

Author Comment

by:Cook09
ID: 24366378
How would I do that in a .bat file?  

If it was done in VBscript, where would it go, and/or how would VBscript be loaded to  monitor the application?
0
 
LVL 17

Assisted Solution

by:Shanmuga Sundaram
Shanmuga Sundaram earned 800 total points
ID: 24366463
open notepad and save this as sample.vbs

Set wshShell = WScript.CreateObject ("WSCript.shell")
wshShell.Run """c:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"""
wshShell.Run """c:\Program Files\Microsoft Office\OFFICE11\winword.EXE"""

on executing this, this will run excel and word. This is give you some idea on using vbscript for running multiple applications parallely
0
 

Accepted Solution

by:
Cook09 earned 0 total points
ID: 24366581
Yes, I did that and they both started.  Obviously, I'll need a switch to make Excel full screen, but the main question, since I'm somewhat of a novice with this is, if I have a program, lets say PotonMeter, how does Sample VBS get loaded, in order to start Excel.exe, when the shortcut for ProtonMeter is clicked?
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
While Plesk offers many potential benefits to website administrators, including compatibility with Windows Server and other leading technologies, the company has also been working to differentiate it from other control panels for content management…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question