Need help reading IE textarea using Excel 2010 VBA

Hello,

I am trying to read the value of a IE8 textarea using Excel 2010 VBA 7. The error I get is: "Object doesn't support this property or method" in relation to this line of code:
OldNotes = OldNotes.Value

I have also tried .innerText instead of .Value and get the same error.

Here is the website source that relates to the textarea:

Please Login or Register  to view this content.

Here is the VBA code I am using to try and read the text area:

Please Login or Register  to view this content.

Thanks in advance,
Matt

Thanks for your suggestions, but I get the same error: "Object doesn't support this property or method".

A textarea can be defined as an Object, and .Vaule and .innerText are valid properties, correct?

I've also tried defining it as an HTMLTextArea and HTMLTextAreaElement. If I don't use "Set Oldnotes" I get an Object variable not set error, if I do use "Set Oldnotes", I get a Type mismatch error.

The script worked when the data was just in a table, but now that it's in a textarea, it doesn't. I've been trying to solve this for several days with no luck, it’s very frustrating.

Maybe this will help someone figure it out. I've attached a workbook with an example. Just click the "Read Textarea" button and it will open a webpage that has a textarea in it. It will then attempt to read the textarea and display it in a message box, but it will give the error I'm getting. For some reason I am unable to get the Value or innerText of a textarea.

If you would prefer to create a new workbook, here is the code. Just make sure you add the Microsoft Internet Controls Reference and the Microsoft HTML Object Library Reference in the visual basic editor (Tools->References) or it won't run:

Please Login or Register  to view this content.

Thanks for the help. Your suggestion worked on the example I provided. Unfortunately I still get the same error on the website I am trying to pull from. Unfortunately it's an intranet website, so I can't post the exact problem. This is a step in the right direction though. I'll keep plugging away at it and post the solution once I find it.

I think I've narrowed down the problem, but I don't know how to fix it yet. The textarea I am trying to pull a value from is in a popup radwindow. I need to figure out how to get my code to focus on the radwindow.

I'm marking this Thread as solved. The correction by AlphaFrog allows me to get the value of a textarea. My issue now is figuring out how to pull the information I need from a Child Window. I'll start a new Thread, as it is an unrelated issue.