SHDocVw.InternetExplorer
I've written several VBA macros in Excel to collect data from selec
websites daily, but would like to speed up the process. Currently, just open each webpage as a workbook which can take a lot of tim depending on the amount of graphics on the pages. A book says it is possible to create hidden instances of IE, openin script files and scanning for the information wanted. Yet VBA reject the following line saying that "User-defined type not defined." Dim oIE As SHDocVw.InternetExplorer How and where do I find the correct object library and how do I instal it? or is ther just something I am doing wrong? I have IE 6.0 an scanned and found SHDocVw.dll. Thanks -- Message posted from http://www.ExcelForum.com |
SHDocVw.InternetExplorer
In VBA, go to the Tools menu, choose References, and scroll down
to Microsoft Internet Controls and put a check next to it. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pslm1271 " wrote in message ... I've written several VBA macros in Excel to collect data from select websites daily, but would like to speed up the process. Currently, I just open each webpage as a workbook which can take a lot of time depending on the amount of graphics on the pages. A book says it is possible to create hidden instances of IE, opening script files and scanning for the information wanted. Yet VBA rejects the following line saying that "User-defined type not defined." Dim oIE As SHDocVw.InternetExplorer How and where do I find the correct object library and how do I install it? or is ther just something I am doing wrong? I have IE 6.0 and scanned and found SHDocVw.dll. Thanks! --- Message posted from http://www.ExcelForum.com/ |
SHDocVw.InternetExplorer
to add another approach:
http://groups.google.com/groups?thre...GP12.phx .gbl I was successful with innertext while the OP used innerhtml I think both are valid, but it may depend on the what you want and what is available on the page. -- Regards, Tom Ogilvy "Pslm1271 " wrote in message ... I've written several VBA macros in Excel to collect data from select websites daily, but would like to speed up the process. Currently, I just open each webpage as a workbook which can take a lot of time depending on the amount of graphics on the pages. A book says it is possible to create hidden instances of IE, opening script files and scanning for the information wanted. Yet VBA rejects the following line saying that "User-defined type not defined." Dim oIE As SHDocVw.InternetExplorer How and where do I find the correct object library and how do I install it? or is ther just something I am doing wrong? I have IE 6.0 and scanned and found SHDocVw.dll. Thanks! --- Message posted from http://www.ExcelForum.com/ |
SHDocVw.InternetExplorer
Thanks to you both, that did the trick. Very helpful replies
-- Message posted from http://www.ExcelForum.com |
All times are GMT +1. The time now is 04:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com