Macro to run external application and login into it.
 

Dear Experts,

I need your help.

I have an application called Agent.exe which i use to import data from
finger print terminals. When i run the application, it shows a dialog box to
enter the user name and password. after i enter the correct user name and
password,the application runs and starts fetching the log from the terminals
which is then stored into a MDB file.

I have created a macro which connects to the MDB file, imports the data and
then export s it to CSV but each time i have to do it, i have to open the
Agent.exe application so that the MDB gets updated with the latest logs.
Therefore I need an excel macro which can run Agent.exe installed at
c:\program files\Agent\Agent.exe and login into it with username = "Admin"
and Password = "Password"

Thanks in advance,
--
Best Regards,
Jitendra Kumar

Macro to run external application and login into it.
 

You can use the Shell command to launch the applicaiton but to log in is a
different matter.

Shell ("C:\program files\Agent\Agent.exe")

You can use send keys to log in but that is hit and miss. I am not familiar
with Agent but is you do some research on that specific program you may find
that there is a way to span and log into the application via an API call or
such.
--
HTH...

Jim Thomlinson


"Jitendra Kumar" wrote:

Dear Experts,

I need your help.

I have an application called Agent.exe which i use to import data from
finger print terminals. When i run the application, it shows a dialog box to
enter the user name and password. after i enter the correct user name and
password,the application runs and starts fetching the log from the terminals
which is then stored into a MDB file.

I have created a macro which connects to the MDB file, imports the data and
then export s it to CSV but each time i have to do it, i have to open the
Agent.exe application so that the MDB gets updated with the latest logs.
Therefore I need an excel macro which can run Agent.exe installed at
c:\program files\Agent\Agent.exe and login into it with username = "Admin"
and Password = "Password"

Thanks in advance,
--
Best Regards,
Jitendra Kumar