How to create a vba code to extract a string of data from the “View Source” code from an active IE window into a cell in excel? Part 2

This is a continuation from a previous question.  I need to modify this code so that when there is only one record shown and it’s missing a frame the data will still populate.  I have attached a debug file that was generated by the “IE-Pull-Data.NoDebug” file that ltlbearand3 created.  The target data is listed in multiple places, but each occurrence is highlighted.

(Ticket Number)
(Machine name)
(Alt ticket number)
(Journal Updates)
(POC Name)
(POC Phone Number)
(Location Code)
(Related Ticket Number)

Link to previous question
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NorieAnalyst Assistant Commented:
Are you trying to extract data from a webpage?

If you are there could be other (better?) ways to do it rather than looking at the source code.
kbay808Author Commented:
Yes I am trying to extract data from a website. The question is miss leading, because the solution from the first part extract the data in a different way.  Please view the debug file for the current code.

I think Norie is trying to get you to think through the options that may exist for getting the data.  For example, might it be possible to set up a connection straight to the database (like via OLEDB or ODBC)?  Something to consider.

Going forward with having to extract from the website, i will take a look at the debug.  However, that is from Debug 11, could you post the debug from IE-Pull-Data.1.xlsm?  I would like to see a file from one that works and one from a ticket that does not work.  That may help in comparing the two to find a method to handle the missing frame.  I am digging through the one you did post to see what I can find right now.
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

NorieAnalyst Assistant Commented:
I was actually thinking more along the lines of XMLHTTP or automating IE.

Using either of those methods you would have access to the DOM of the web page which in turn gives you acces to all the elements on the page.
Okay.  I think I have an idea.  Please run this file on both scenarios,  See if it works and post the debug file from each scenario.  Thanks.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
@Norie - the other thread is pretty long but we cannot use either of those options as we don't have access to the page through those methods.  The user must log in to the site and navigate to the specific information first.  Therefore we have to use the active IE window.  You can look at the other thread and see if Ron (IrogSinta) and I missed anything.
kbay808Author Commented:
@ltlbearand3 – Awesome Job!!!  You got this down pat now.  It worked perfect on the first try.  There is no need to modify the code.  I was able to figure out how to remove the debug portion with no problem.

I will be posting another question within the next couple of days that I hope that you can take a look at.  It’s the same thing, but for closed tickets.  It must be in a different iframe.   I will post the question after I get a chance to sanitize the debug files (for when there are multiple tickets and for when there is only 1 ticket).  I’ll send you a message with the link after I post it.

Thanks again
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VB Script

From novice to tech pro — start learning today.