it is in the references of a VBA project in an excel workbook by default. you can run a test yourself and see by looking at intellisense and seeing what you get with it. Note that innerText and innerHTML are string types and your code is assigning it to an object, which is wrong. and I believe the full DOM platform and every qualifying thing in it is available for use with that library. Try instead: Code: Dim myText As String myText ie.document.All ('lblCustSiDt').innerText. => probably others too, although I have not used any of them.Īlso, if you did not know, VBA has had for many years, a full blown object library called ''HTML object library''.

some of the best that have really good capabilities for manipulating the internet through a browser program are:

there are massive library resources available in almost any desktop language. In terms of using other languages to automate browser objects and literally do anything on the web you want, like web scraping (which you are *kind of* doing, but in reverse, by entering data into HTML elements and stuff), you can use almost anything to do this. here it is: automate internet explorer using VBA however, this 'force feeding' effort by MS only started about 5 months ago, or there abouts.Īnd by the way, I did *not* include any link. if you experiment with this whole thing, you'll notice it very quickly. it just recognizes it as the default browser because MS is forcing it via windows updates through the internet. Well, VBA does NOT technically launch edge.

Vba internet explorer document