A
Al
I've a workbook called "Wheels".
It contains multiple sheets.
One sheet named "Values" & is setup such that Col A has hyperlinks and
the remaining columns are to contain the data from a web page related to
that link.
Another sheet is called "Import".
I've written code (let's call it "Sub Transfer()" )that opens the web
page from the link using:
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
I then MANUALLY do a SELECT ALL & COPY in IE.
My code then pastes the web page, as text, onto Sheet2 using:
Columns("A:A").Select
ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _
DisplayAsIcon:=False
From this sheet, I manipulate the data & paste the required info onto
the sheet "Values".
I then MANUALLY close the web page. (I've got over 1K of links so I
can't keep them open in IE)
My code then selects the next hyperlink & I repeat the process.
How might I use VBA to automate the MANUAL steps?
It contains multiple sheets.
One sheet named "Values" & is setup such that Col A has hyperlinks and
the remaining columns are to contain the data from a web page related to
that link.
Another sheet is called "Import".
I've written code (let's call it "Sub Transfer()" )that opens the web
page from the link using:
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
I then MANUALLY do a SELECT ALL & COPY in IE.
My code then pastes the web page, as text, onto Sheet2 using:
Columns("A:A").Select
ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _
DisplayAsIcon:=False
From this sheet, I manipulate the data & paste the required info onto
the sheet "Values".
I then MANUALLY close the web page. (I've got over 1K of links so I
can't keep them open in IE)
My code then selects the next hyperlink & I repeat the process.
How might I use VBA to automate the MANUAL steps?