Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External data connection needs separate login for each query | Excel Discussion (Misc queries) | |||
Identify User, Copy/Paste Login Info. to External File | Excel Programming | |||
Login date & time to the VBA application. | Excel Programming | |||
external web query? (sites that require login) | Excel Discussion (Misc queries) | |||
"Open With" external application macro | Excel Programming |