Opening other applications in excel
 

Hi,

I've got a unique situation here, being lazy i use excel macros to the
fullest to automate my tasks. Comming to my problem, everyday at 8 am I
need to download 9 files from a application called DAP (download
accelerator plus). I need to automate this activity!

I am thing about using schedule task feature to open an excel file.
Once the xls file is open, a macro should run on the on open event to
open DAP, enter its user name and pwd then down load these files....

I have a gutt feeling that this is possible... (as i have done this to
open internet explorer).. Just want to see if someone can help me

Hints:
Location where my DAP application is situated.
"C:\Program Files\DAP\DAP.exe"
There are 15 *.DLL files in this folder.
cabex.dll
DAPBHO.dll
dapie.dll
DAPIEBar.dll
dapm_Context_search.dll
dapm_ftp.dll
dapmm.dll
dapns.dll
dapop.dll
dapres32.dll
dapres.dll
MCMgr.dll
mfc42.dll
msvcrt.dll
zlib.dll

The 9 file i download have name format as e.g "chain1_dump_yymmdd",
"chain9_dump_yymmdd"

These files are stored on an FTP location xxx.xx.x.xxx accessed via DAP

Regards,
Unmesh Raut