PDA

View Full Version : Getting a value from a HTML Object pasted to a Worksheet



afslaughter
12-11-2012, 06:22 AM
Greetings all, I tried looking through the help files and Google for HTMLName with no luck. I am doing a select all from a web page and pasting it to a worksheet to grab some of the info. I was able to get the value by referencing the object name but I don’t think I can count on that . I see that the HTML Name is consistent and I would really like to use that. Many thanks for any help I can get.

This works (object Name)
test = Me.HTMLText1.Value

This does not (HTML Name)
test = Me.OLEObjects. HTMLName.R23_C48_L12_N.Value