For a year and a half now i am faced with a frustrating problem in Excel; i started learning VBA and XML but it didn't do any good at all! I just didn't find any books with a relevant topic and Microsoft's help is pretty unhelpful! In a last-ditch effort, i taped it on a video searching for anyone who could help to maximize the potential of getting a bulls-eye answer and finally move forward constructing an economic model. My video shows analytically how i am stuck!!!
Please any help will be gold, i have a basic understanding of VBA and XML(read some books). I simply cannot give any more man-hours and i need your help!!!
Thank you, Marinos
PS: My video has a 16 sec intro. Couldn't resist it!+Any other way to automatically parse an XBRL document fast and efficiently and plug it's data into the mapped cells of a worksheet will be tons of help...!
Here is how we do it at my company:
http://localhost:8080/basex.....
). You create a Table on Excel with that URL as source, or you can call it from VBA using the XMLHttpRequest object.Hope you find this info useful.