Log in

View Full Version : Copy/Paste specific data from different pages of same website using VBA code



excel_1317
03-11-2014, 05:05 PM
Is it possible to develop a code which open each each name from this page- http://www.fitzpatrickcella.com/?p=2541&FirstName=&LastName=&LPA=&I=&L=&Rank=

AND

copy details like Attorney Name, email, phone and fax nos. and paste the same into excel rows.

Thanks in advance.



PS: I have also posted this question at Import data from multiple pages of a website into a single Excel sheet (http://www.mrexcel.com/forum/excel-questions/646794-import-data-multiple-pages-website-into-single-excel-sheet.html#post3742777)

excel_1317
03-11-2014, 06:03 PM
Is it possible to develop a code which open each each name from this page- http://www.fitzpatrickcella.com/?p=2541&FirstName=&LastName=&LPA=&I=&L=&Rank=

AND

copy details like Attorney Name, email, phone and fax nos. and paste the same into excel rows.

Thanks in advance.



PS: I have also posted this question at Import data from multiple pages of a website into a single Excel sheet (http://www.mrexcel.com/forum/excel-questions/646794-import-data-multiple-pages-website-into-single-excel-sheet.html#post3742777)


This is now resolved.