Opening other applications in excel

[unmesh.raut]

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

 

[NickHK]

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

NickHK

 

[unmesh.raut]

I am afraid that will take too much time....each file is approx
100MB.... the uploading of the files is done by ~7:50am.... each file
takes around 40mins to download and I can download 2 files at any
time....i am alloted 3 comps to do this i.e ... in 40mins i download 6
files i.e 2files x 3comp... and remaining 3 in another 40 mins... Total
download time aprox 1hrs 30mins

I need to make this report... and send it out latest by 9:30am... I
have automated the excel part... I need to automate the download part.
I need to start the download activity at 8am....irrespectve of my
presence..

 

[NickHK]

Without knowing about this DAP, I can't tell you. If you can automate it,
you will be able add it as a reference.
But you can schedule a script/excel to run at the required time to download
the files from each computer.

NickHK

 

[unmesh.raut]

I want to know how? Can you provide me with codes ....

 

[NickHK]

http://www.google.co.uk/search?hl=en&q=FTP+VBA&btnG=Google+Search

http://www.google.co.uk/search?hl=en&q=Windows+Scheduler

http://www.google.co.uk/search?hl=e...=0&ct=result&cd=1&q=IE+automation+VBA&spell=1

But a 2 second look at the DAP website told me:
"Download Accelerator Plus (DAP) is the leading download manager ......,
NickHK