Solved

Start Excel when a Third Party Application is Started

Posted on 2009-05-12
4
432 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 200 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now