View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RayportingMonkey RayportingMonkey is offline
external usenet poster
 
Posts: 87
Default Launch Excel On Event?

OK, so this is not a VBA question and not even really an Excel question, so
if this is not the right place to pose the request, kindly point me in the
right direction!

I have a pretty jammin' desktop that I use for development and to run the
automation for my reports - most of which are in Excel. I often work offsite
and use my laptop and VPN connection to access the desktop.

I have automation that grabs my various source files from multiple locations
/ platforms but the timing of these files arriving is not consistent. I need
to get them into my reports as quickly as I can, so I constantly look for
ways to automate this process further!

The issue I am having right now is that I need to launch Excel (on my
desktop) when a certain event occours or a condition becomes true on the
computer and I'm not sure how to do that...

I don't want to simply schedule a task to run at a certian time for various
reasons. I just think it would be best to launch the application when I
"know" it will run successfully.

I guess the "old-school" method woud be to setup a TSR-Program, but I can't
find any info on how to do that and Windows Scheduler only deals with
date/time or login variables, so I don't see how I could make that work.

Any help is appreciated - thank you so much.

Later-
Ray

--
"Trying to make reports so easy... even a monkey could run ''em!"