Determine the value of a shape (radio button) programmatically

Hey folks. I've inherited a process that has hundreds of identical PDF forms filled out and I now need to scrape the data out of it. I'm able to export the PDF to Excel and now most of the data is a set of radio buttons (as shapes) in a row with a few dropdowns and some text boxes. Does anyone know how to get the value of the individual radio buttons in VBA? I've hunted high and low and see now 'value' property. Do I need to cast the shape to something else? Is there a 'hidden' property? Can I tell somehow from the shape's formatting whether it's been pressed or not? (Note that the form is filled in as a PDF so there's no way to run event code. I have to read it after the fact.) Any help would be hugely appreciated.

I don't think there is anyway to get a property from these; they're just pictures rather than controls. That said all the images of a selected radio buttons are (at least on this occasion) called "image1.png". Therefore, you can use the name to identify them.

e.g.

Please Login or Register  to view this content.

Yes, I've reached the same conclusion. Not sure it will always be image1.png but I'll see if that's the case. Unfortunate that the PDF export uses pictures. But I'll see what I can do

Thanks anyway.

I'll close the thread

Hmm. I'm new at this (first post). I don't see how to close the thread. Is that something we should do? Or is it just left?

You can mark it SOLVED under Thread Tools, but you may want to leave it open in case someone else has an idea.