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.