On Feb 17, 10:27*am, AB wrote:
Have you tried
value=
property?

Or read the
InnerText
property as a string and then work with the string?

On Feb 17, 9:34*am, Harrison Hill wrote:



On Feb 16, 5:38*pm, GS wrote:

Harrison Hill wrote on 2/16/2011 :

Does anyone have a link to the properties of the HTMLSubmit button
control?

A simple obj.caption doesn't seem to work.

TIA

What's the HTMLSubmit control? Is this in v12 or higher? If so, is this
what you want?

* Application.CommandBars.ExecuteMSO("FilePublishAsW ebPage")

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

I don't want to fire up the button, I just want to read the text that
is in its centre. It is one of a large number of buttons on a webite,
of which this is one:

Name: HTMLSubmit1
Encoding: application/x-www-form-urlencoded
HTMLName: _id144:results:0:_id159
Caption:19/2011/0162

(according to Excel 2000 "Properties")

It is that Caption I want to read

"InnerText" I hadn't thought of, but it isn't that. It isn't "Value"
or "Text". A "Record Macro" of the text being edited looks like this
(no mention of the edit itself):

Sub Macro1()
ActiveSheet.Shapes("Control 1").Select
Selection.Verb Verb:=xlPrimary
End Sub

Nor is it "Verb" or "Characters" or anything to do with "Interior".

In the unlikely event you would like to see one of these buttons, they
are the left hand "Data" column if you insert two dates into this
website. Paste a few rows into Excel, and the button forms thus
cunningly "hiding" the data - you can look at it but you cannot
process it!

http://planning.denbighshire.gov.uk/...am=lg.Planning