Hi,

I'm fairly new to macros and vba so I really apologize in advance. I'm trying to create a macro to obtain some information from IE which is in HTML format but I just don't know how. Where i work we use a program called SAP to process orders. I can create macros and pull any info i want from this program but It's hard for me to do it from Internet explorer.

This is the Macro I use to open IE which contains the info i need. 

Please Login or Register  to view this content.
Now, this is part of the html body. How can i transfer the data i need back to excel?
For example, the value I want from here is: "RITM1169936" (Picture Attached)



Macro.PNG

I would really appreciate if anyone could help me or at least point me in the right direction.
Thank you !