chungtinhlak
05-22-2009, 06:31 AM
Every morning, I have to go out to a site and save a bunch of Excel files (18 of them). The links are really long so I used FollowHyperlink, these links are not a direct links to the file, it's encrypted. In another worth, they don't end in .xls.
Example of link:
https://cogentprod.web.company_name.com:443/cbi1/cgi-bin/cognosisapi.dll?b_action=cognosViewer&ui.action=view&ui.object=defaultOutput%28%2fcontent%2ffolder%5b%40name%3d%27787%20Producti on%20System%20Reports%20and%20Metrics%27%5d%2ffolder%5b%40name%3d%27Shop%20 Floor%20Information%27%5d%2ffolder%5b%40name%3d%27Special%20Report%20Views% 27%5d%2ffolder%5b%40name%3d%27QA%27%5d%2ffolder%5b%40name%3d%27Scheduled%20 Report%27%5d%2freportView%5b%40name%3d%27EPD%20Backlog%20Report%20Morning%2 7%5d%29&ui.name=EPD%20Backlog%20Report%20Morning&ui.format=singleXLS"]https://cogentprod.web.company_name.com:443/cbi1/cgi-bin/cognosisapi.dll?b_action=cognosViewer&ui.action=view&ui.object=defaultOutput(%2fcontent%2ffolder%5b%40name%3d%27787%20Production %20System%20Reports%20and%20Metrics%27%5d%2ffolder%5b%40name%3d%27Shop%20Fl oor%20Information%27%5d%2ffolder%5b%40name%3d%27Special%20Report%20Views%27 %5d%2ffolder%5b%40name%3d%27QA%27%5d%2ffolder%5b%40name%3d%27Scheduled%20Re port%27%5d%2freportView%5b%40name%3d%27EPD%20Backlog%20Report%20Morning%27% 5d)&ui.name=EPD%20Backlog%20Report%20Morning&ui.format=singleXLS
I was able to use followhyperlink but a messagebox pop up asking me to save, open or cancel. How do I automatically save it everytime in a certain directory with the same name everytime?
thanks
Example of link:
https://cogentprod.web.company_name.com:443/cbi1/cgi-bin/cognosisapi.dll?b_action=cognosViewer&ui.action=view&ui.object=defaultOutput%28%2fcontent%2ffolder%5b%40name%3d%27787%20Producti on%20System%20Reports%20and%20Metrics%27%5d%2ffolder%5b%40name%3d%27Shop%20 Floor%20Information%27%5d%2ffolder%5b%40name%3d%27Special%20Report%20Views% 27%5d%2ffolder%5b%40name%3d%27QA%27%5d%2ffolder%5b%40name%3d%27Scheduled%20 Report%27%5d%2freportView%5b%40name%3d%27EPD%20Backlog%20Report%20Morning%2 7%5d%29&ui.name=EPD%20Backlog%20Report%20Morning&ui.format=singleXLS"]https://cogentprod.web.company_name.com:443/cbi1/cgi-bin/cognosisapi.dll?b_action=cognosViewer&ui.action=view&ui.object=defaultOutput(%2fcontent%2ffolder%5b%40name%3d%27787%20Production %20System%20Reports%20and%20Metrics%27%5d%2ffolder%5b%40name%3d%27Shop%20Fl oor%20Information%27%5d%2ffolder%5b%40name%3d%27Special%20Report%20Views%27 %5d%2ffolder%5b%40name%3d%27QA%27%5d%2ffolder%5b%40name%3d%27Scheduled%20Re port%27%5d%2freportView%5b%40name%3d%27EPD%20Backlog%20Report%20Morning%27% 5d)&ui.name=EPD%20Backlog%20Report%20Morning&ui.format=singleXLS
I was able to use followhyperlink but a messagebox pop up asking me to save, open or cancel. How do I automatically save it everytime in a certain directory with the same name everytime?
thanks