Re: Download files without alerts by Excel VBA

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

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: Same update keeps installing every time
    ... > difference I can see is I do not have SystemRoot folder. ... > Regards Garry ... >> Copy Folders Download and DataStore to another location ... >> Double click Automatic Updates service and click START ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Black out on screen
    ... This is happening due to graphic card driver.You have to update the driver.Visit the manufacturer's website to download and intall the latest driver. ... retta wrote: ...
    (microsoft.public.windowsxp.general)
  • Re: Download files without alerts by Excel VBA
    ... like you need automate the manual interaction with the web page of figure ... Regards, ... Tom Ogilvy ... > In fact there is no ditect link to download the file. ...
    (microsoft.public.excel.programming)
  • Re: VFP9 Product Key
    ... > Take a closer look at the screen from which you download. ... > particular key for Version 9, and it is needed for the install, as you ... > Best regards. ... >> And where can I find the managed groups for MSDN subscribers. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Opening MS WORD document from database
    ... Regards ... Daniel Walzenbach ... Any file i try to download gives ... > Private Sub Page_Load(ByVal sender As System.Object, ...
    (microsoft.public.dotnet.framework.aspnet)