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

My first thoughts would be forget DAP, and download either with FTP code or
automatic IE.
Possible ?

NickHK

wrote in message
oups.com...
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