+ Reply to Thread
Results 1 to 4 of 4

Download files without alerts by Excel VBA

  1. #1
    Shetty
    Guest

    Download files without alerts by Excel VBA

    Hi,
    I have to download around 130 files from our intranet every week.
    I have written code for the same. But there is a small issue.
    When each file is downloaded, a alert saying file download, open,save
    is displayed. I have to click save. Then it asks the directory and save
    as, again I have to click save. It means for each file I have to click
    twice.
    Can I avoid it? May be I can predefined the directory in vba so that
    all the files are downloaded one by one to that dir without need to
    click on alerts. But how to inform this dir to vba and how to ask vba
    to straight away download the file without asking me?

    Hoping for some solution....

    Regards,
    Shetty.


  2. #2
    Tom Ogilvy
    Guest

    Re: Download files without alerts by Excel VBA

    you can't use the copy command?

    if not, then how about ftp?

    --
    Regards,
    Tom Ogilvy

    "Shetty" <[email protected]> wrote in message
    news:[email protected]...
    > Hi,
    > I have to download around 130 files from our intranet every week.
    > I have written code for the same. But there is a small issue.
    > When each file is downloaded, a alert saying file download, open,save
    > is displayed. I have to click save. Then it asks the directory and save
    > as, again I have to click save. It means for each file I have to click
    > twice.
    > Can I avoid it? May be I can predefined the directory in vba so that
    > all the files are downloaded one by one to that dir without need to
    > click on alerts. But how to inform this dir to vba and how to ask vba
    > to straight away download the file without asking me?
    >
    > Hoping for some solution....
    >
    > Regards,
    > Shetty.
    >




  3. #3
    Shetty
    Guest

    Re: Download files without alerts by Excel VBA

    Hey Tom,
    I know you will come to my rescue. You also helped me earlir.

    NO. Copy or ftp is not available.
    In fact there is no ditect link to download the file. The link consist
    of a java script having dolaunch command. The software they are using
    is Lotus Domino docs. I put displayalerts=false in my code but it seems
    that it is limited to only excel or office applications. Is it possible
    to get rid of these dialog boxes?

    Thanks for reply.
    Regards,
    Shetty.

    Tom Ogilvy wrote:
    > you can't use the copy command?
    >
    > if not, then how about ftp?
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    > "Shetty" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hi,
    > > I have to download around 130 files from our intranet every week.
    > > I have written code for the same. But there is a small issue.
    > > When each file is downloaded, a alert saying file download,

    open,save
    > > is displayed. I have to click save. Then it asks the directory and

    save
    > > as, again I have to click save. It means for each file I have to

    click
    > > twice.
    > > Can I avoid it? May be I can predefined the directory in vba so

    that
    > > all the files are downloaded one by one to that dir without need to
    > > click on alerts. But how to inform this dir to vba and how to ask

    vba
    > > to straight away download the file without asking me?
    > >
    > > Hoping for some solution....
    > >
    > > Regards,
    > > Shetty.
    > >



  4. #4
    Tom Ogilvy
    Guest

    Re: Download files without alerts by Excel VBA

    Sorry to disappoint, but web programming isn't something I do. It sounds
    like you need automate the manual interaction with the web page of figure
    out a way to programmatically interact with the web page. I think you best
    bet is to contact the providers of the web page or whatever and see what
    they recommend.

    --
    Regards,
    Tom Ogilvy

    "Shetty" <[email protected]> wrote in message
    news:[email protected]...
    > Hey Tom,
    > I know you will come to my rescue. You also helped me earlir.
    >
    > NO. Copy or ftp is not available.
    > In fact there is no ditect link to download the file. The link consist
    > of a java script having dolaunch command. The software they are using
    > is Lotus Domino docs. I put displayalerts=false in my code but it seems
    > that it is limited to only excel or office applications. Is it possible
    > to get rid of these dialog boxes?
    >
    > Thanks for reply.
    > Regards,
    > Shetty.
    >
    > Tom Ogilvy wrote:
    > > you can't use the copy command?
    > >
    > > if not, then how about ftp?
    > >
    > > --
    > > Regards,
    > > Tom Ogilvy
    > >
    > > "Shetty" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > Hi,
    > > > I have to download around 130 files from our intranet every week.
    > > > I have written code for the same. But there is a small issue.
    > > > When each file is downloaded, a alert saying file download,

    > open,save
    > > > is displayed. I have to click save. Then it asks the directory and

    > save
    > > > as, again I have to click save. It means for each file I have to

    > click
    > > > twice.
    > > > Can I avoid it? May be I can predefined the directory in vba so

    > that
    > > > all the files are downloaded one by one to that dir without need to
    > > > click on alerts. But how to inform this dir to vba and how to ask

    > vba
    > > > to straight away download the file without asking me?
    > > >
    > > > Hoping for some solution....
    > > >
    > > > Regards,
    > > > Shetty.
    > > >

    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1