Re: Download files without alerts by Excel VBA

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <shetty@xxxxxxxxx> wrote in message
> news:1114087528.382432.266460@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > 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.
> >

.

Relevant Pages

  • Re: Linking to a txt file which is Located on the Internet
    ... You can download the file via FTP, ... Is it possible using VBA and Ms Access to Link to a txt file which is ... located in you PC or somewhere in a LAN? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Linking to a txt file which is Located on the Internet
    ... You can download the file via FTP, ... Is it possible using VBA and Ms Access to Link to a txt file which is ... located in you PC or somewhere in a LAN? ...
    (microsoft.public.access.modulesdaovba)
  • >>>> VBA DOWNLOAD <<<<
    ... access 2000 vba tutorial download, all vba pokemon games download, all ... vba rom download, digimon vba roms download, digimon vba roms download ...
    (sci.agriculture)
  • RE: SBS 2003 Premium: how to allow FTP .EXE downloads
    ... Disable the problematic client XP firewall, ... click to check the "Hide All Microsoft Services" ... Is the FTP server on SBS? ... Download the file from the following URL: ...
    (microsoft.public.windows.server.sbs)
  • Re: Inability to download with IE6
    ... > could be accessed by the laptop. ... The Status bar shows that there are ftp URLs there. ... Ethereal could be used to help format the traces but even though the ... When I attempted to download, the page came up that says the site ...
    (microsoft.public.windows.inetexplorer.ie6.browser)