Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Downloading of files (PDF or HTML) using Excel
Hi,
Strange requests.. a) I want to download all the conference papers of a particular SAS user group proceedings (Statistics software). The SAS website says that http://support.sas.com/usergroups/su...ngs/index.html the papers are intended for viewing through browser only. If downloaded then the hyper-links would not work. Im not worried about hyperlinks not being available. Each of the conference paper is a separate PDF file. http://www2.sas.com/proceedings/sugi29/toc.html . Like for this particular conference 270 papers were published. The links for all papers are in a regular pattern, like the first paper link is http://www2.sas.com/proceedings/sugi29/001-29.pdf , the second paper is http://www2.sas.com/proceedings/sugi29/002-29.pdf .... and the 270th paper is http://www2.sas.com/proceedings/sugi29/270-29.pdf. Using EXCEL can one download all the papers to a specified directory in my computer. I plan to list all the paper links in excel on the Column A of a workbook (Listing them would be easy by using Excel's concatenate function). Can a macro read the link on each of the cells one by one and do a download. How does one go about it. b) In point a) all the web-page links were in a specific pattern, so listing them out in a Excel worksheet is no sweat. But suppose they were not in any pattern, then how would one approach the problem. Is it possible for an Excel macro to READ all the web-links in a particular HTML file and list out the links one by one in a Excel Workbook. This method would be handy if I have to download all the links on a particular web-page considering that the names of those links are not in a specific pattern. c) I want to download all the html pages WITHIN www.solver.com in a specified directory on my computer. If I give the PARENT link in a particular cell in EXCEL, is it possible for a macro to download all the web pages under the SOLVER domain? I want to be able to do this using Excel (would help me in understanding Excel's INTERACTION with NON-Office applications.) (As an aside, if there are smarter ways to do this outside of excel, would be glad to know.) Thanks a lot, Hari India |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Downloading quickbooks files to Excel 2007 | Excel Discussion (Misc queries) | |||
Downloading newer files to older excel versions. | Excel Discussion (Misc queries) | |||
Downloading files from an Intranet site to Excel | Excel Discussion (Misc queries) | |||
Downloading Files Using Excel | Excel Discussion (Misc queries) |