0

A very tricky VBA Question

THIS QUESTION WILL BE ANSWERED IN ENTIRETY BY POSTING WITH THE RELEVANT STACK LINKS AS AN ANSWER A FULLY FUNCTIONAL MACRO TO USE AS BEDROCK FOR ANYONE WHO WANTS TO START DEVELOPING A FINANCIAL MODEL. I AM CURRENTLY WORKING ON IT.

The ExoticBirdsMerchant

How can i pull an XML element from a web location like this one for example:

http://www.sec.gov/Archives/edgar/data/10795/000119312513456802/bdx-20130930.xml

by using VBA and put that value in an Excel cell??? If you could provide the basic code and an explanation on how it is done and what references do i need to activate from tools in VBE it will mean the world for me.... Keep in mind i am a little beginner....

Keep up the good work guys

ExoticBirdsMerchant
  • 1,466
  • 8
  • 28
  • 53
  • 3
    This is not really the place for this type of question. Maybe start here: http://www.google.com/webhp?nord=1#nord=1&q=vba+xml+tutorial&safe=off and come back with a specific question after you've tried a couple of things. – Tim Williams Jan 28 '14 at 19:53
  • I've tried many ways for a long long time to do this i just put up a general question because i believed that a holistic approach would be very intuitive for me. If this is not allowed i am really sorry – ExoticBirdsMerchant Jan 28 '14 at 20:29
  • The solution actually now resides in VBA pull XML data to Excel – ExoticBirdsMerchant Feb 11 '14 at 23:22

0 Answers0