Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Download files without alerts by Excel VBA
you can't use the copy command?
if not, then how about ftp? -- Regards, Tom Ogilvy "Shetty" wrote in message oups.com... 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" wrote in message oups.com... 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" wrote in message oups.com... 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" wrote in message oups.com... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
download to be able to save files as CSV in Excel? | Excel Discussion (Misc queries) | |||
Can Excel download files? | Excel Programming | |||
Process excel files, suppress alerts | Excel Programming | |||
Bulk Download of Excel Files | Excel Programming | |||
Download files with excel | Excel Programming |