Solved

Start Excel when a Third Party Application is Started

Posted on 2009-05-12
4
442 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Invest in your employees with these five simple steps to improve employee engagement and retention.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

626 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