troubleshooting Question

Launch an Application Reference appref-ms

Avatar of newtovista
newtovista asked on
.NET ProgrammingMicrosoft Development
2 Comments1 Solution1539 ViewsLast Modified:
I have a MS Access 2007 application form and would like to launch (From a button in the MS Access Form) an application created by Visual Studio 2008 and installed on the machine. The application I want to launch (run) gathers data from a web service (WCF service) and stuffs it into the Access data base. The reason to do this is to keep all funtionality of my 'application' in MS Access - well at least the operator clicks a button there instead of having to click some icon or file outside of MS Access.
I used to do this with 'shell'  calls when the applications were .exe files.
I have found many suggestions on the net and even one in experts exchange but none work in VBA.   One suggestion was as follows:
 
Public Sub New()
Dim Proc as New Process
Dim Si as New StartInfo
Si.FileName = "C:\Temp\Mytest....."
Proc.StartInfo = Si
...

This looks like what I am looking for but..
there is no reference to 'Process' or 'StartInfo'  in VBA and I do not know what reference to add

So,   Any help for me on this one using ANY method ie perhaps starting a windows batch or ??
  (Geez, can't I just programatically 'click' on the stupid application reference file?)

PS.  There is no guarantee the operator will have I.E. or any browser in the machine.

D

ASKER CERTIFIED SOLUTION
EE_AutoDeleter

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros