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