I am using Excel 2007.
Using Excel VBA, I am supposed to go a specific Web Site's HOME page. On that web HOME page there are a lot of loans which are in the form of Hyper links.
If I can click any Hyperlink, it will take to a web page that is specific to that loan's web page.
Hence, If there are 20 loans, there will be 20 loan specific web pages.
I need to write an Excel VBA code, which would click all the 20 Loan Hyperlinks, go to the 20 loan detail pages and copy all the details into 20 different worksheets.
It is just a "SELECT ALL" and "COPY" of that page, and paste into an Excel Worksheet.
Again, 20 loans is just a number. It may be even 30 loans or 50 loans or 100 loans.
Could some one please suggest an Excel VBA code for this?
Using Excel VBA, I am supposed to go a specific Web Site's HOME page. On that web HOME page there are a lot of loans which are in the form of Hyper links.
If I can click any Hyperlink, it will take to a web page that is specific to that loan's web page.
Hence, If there are 20 loans, there will be 20 loan specific web pages.
I need to write an Excel VBA code, which would click all the 20 Loan Hyperlinks, go to the 20 loan detail pages and copy all the details into 20 different worksheets.
It is just a "SELECT ALL" and "COPY" of that page, and paste into an Excel Worksheet.
Again, 20 loans is just a number. It may be even 30 loans or 50 loans or 100 loans.
Could some one please suggest an Excel VBA code for this?
