Opening other applications in excel

  • Thread starter Thread starter unmesh.raut
  • Start date Start date
U

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
 
My first thoughts would be forget DAP, and download either with FTP code or
automatic IE.
Possible ?

NickHK
 
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..
 
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
 
Back
Top