H
Harry Flashman
I have a tricky question. I am not sure if the answer lies in Excel
VBA or perhaps a commerically available program.
I have a table consisting of hyperlinks to webpages (typically at
least 100 hyperlinks).
I would like to automate the task of navigating to those webpages and
then saving the content of those webpages, preferably as PDFs but
alternatively as .htm, mht files or maybe even as .txt file (at this
stage I am interested in the text on these website, but later I will
probably be interested in images too).
This is how I would envisage the code working:
1. Open first hyperlink with IE8
2. Save webpage
3. Close webpage
4. Open second hyperlink
etc
I have Primo PDF writer installed on my computer which allows me to
print webpages as a pdf. I think perhaps it would be possible to put a
script in the VBA to tell IE8 to print to Primo and SAVE AS (perhaps
the SAVE AS file name could be in one the same row as the URL but in
the next column).
I have been searching the net looking to see if anyone has written
such code or if there are applications I can download that might do
this for me. I have found applications which will print webpages to
pdf but as yet I have not found any that will handle batches of URLs.
So if any one has any suggestions I would greatly appreciate it.
VBA or perhaps a commerically available program.
I have a table consisting of hyperlinks to webpages (typically at
least 100 hyperlinks).
I would like to automate the task of navigating to those webpages and
then saving the content of those webpages, preferably as PDFs but
alternatively as .htm, mht files or maybe even as .txt file (at this
stage I am interested in the text on these website, but later I will
probably be interested in images too).
This is how I would envisage the code working:
1. Open first hyperlink with IE8
2. Save webpage
3. Close webpage
4. Open second hyperlink
etc
I have Primo PDF writer installed on my computer which allows me to
print webpages as a pdf. I think perhaps it would be possible to put a
script in the VBA to tell IE8 to print to Primo and SAVE AS (perhaps
the SAVE AS file name could be in one the same row as the URL but in
the next column).
I have been searching the net looking to see if anyone has written
such code or if there are applications I can download that might do
this for me. I have found applications which will print webpages to
pdf but as yet I have not found any that will handle batches of URLs.
So if any one has any suggestions I would greatly appreciate it.