Excel VBA to extract Instance URLs

Hi,
Would appreciate very much your assistance with an Excel VBA code ( version 2010 ) to extract a list of Instance URLs for all the 10-K filings from the SEC Edgar website for a particular entity ( e.g. its CIK  reference = 0000078003 )

The site is: https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=0000078003&type=10-K&dateb=&owner=exclude&count=20; and when manually extracted the required results of a list of Instance URLs are as follows:
https://www.sec.gov/Archives/edgar/data/78003/000119312510042425/pfe-20091231.xml
https://www.sec.gov/Archives/edgar/data/78003/000119312511048877/pfe-20101231.xml
https://www.sec.gov/Archives/edgar/data/78003/000119312512085703/pfe-20111231.xml
https://www.sec.gov/Archives/edgar/data/78003/000007800313000006/pfe-20121231.xml
https://www.sec.gov/Archives/edgar/data/78003/000007800314000018/pfe-20131231.xml

Would appreciate your assistance with a VBA routine to parse the list programmatically.

Many thanks

=====================
Prior related question: http:Q_28497353.html
RussellbrownAsked:
Who is Participating?
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.

aikimarkCommented:
I don't see pfe-20091231.xml anywhere in the returned source text.
0
Computer EggheadCommented:
Hi Russell,

1) The page you supplied periodically changes.  Therefore, we would need to know why you wanted those particular URLs returned.

2) This site is to help people with their questions, like what you have tried and how you are stuck.  Your question is more like asking someone to provide you a solution for free.
0
aikimarkCommented:
there are also several EE experts who have enabled their Hire Me links.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Computer EggheadCommented:
@aikimark, Yes, and note that those Hire Me links are only available to Premium members.

@Russellbrown, Note that someone edited my answer without consulting me.  In #2 of my answer, I suggested you contact a freelancer to assist you.  You can do that on this site or another, but I am not allowed to recommend any in this comment.  If I was, I could be more helpful to you.
0
RussellbrownAuthor Commented:
@Computer Egghead,
Thank you for your guidance. I have researched the question and have surfed the net extensively to get some pointers. I was not quite able to put my head around the issue and therefore posted the question as a follow up to an earlier question trusting that there might already be an answer to it.  It appears that I will need to do more research and get it up to speed and as suggested tried out the codes and narrow down the issues and revert when stuck.

@aikimark, noted with thanks. I will revert after I have made further progress.

Many thanks.
0

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
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
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
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.