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

Opening other applications in excel
 

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

Opening other applications in excel
 

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

NickHK wrote:
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

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

Opening other applications in excel
 

http://www.google.co.uk/search?hl=en...=Google+Search

http://www.google.co.uk/search?hl=en...dows+Scheduler

http://www.google.co.uk/search?hl=en...on+VBA&spell=1

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

NickHK

wrote in message
ups.com...
I want to know how? Can you provide me with codes ....

NickHK wrote:
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

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