Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to import an xml directly in userform ?
This is my problem:
my application based on excel & vb, dowloads from a website some xml files. Actually i use to import on my worksheets those xmls creating formatted tables very easy to work with. Those infos are then transferred from cells to userform labels, commandbutton etc etc. What i would like to do is improving my code this way: 1° I don't want to import xml content in worksheet 2° i would like to "read" xml "externally" (without opening it) 3° extract the only info i need from each xml and associate then to appropriate Command in the userform (u surely know, when an xml is imported in excel, many tags are repeated in the generated table) How could i solve my problem?? thanks in advance Fulvio Salvo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to import an xml directly in userform ?
Roedd <<furbiuzzu wedi ysgrifennu:
This is my problem: my application based on excel & vb, dowloads from a website some xml files. Actually i use to import on my worksheets those xmls creating formatted tables very easy to work with. Those infos are then transferred from cells to userform labels, commandbutton etc etc. What i would like to do is improving my code this way: 1° I don't want to import xml content in worksheet 2° i would like to "read" xml "externally" (without opening it) 3° extract the only info i need from each xml and associate then to appropriate Command in the userform (u surely know, when an xml is imported in excel, many tags are repeated in the generated table) How could i solve my problem?? You need to use the MSXML library to manipulate the XML DOM. There are plentiful examples on the web from beginner such as http://www.vbcity.com/forums/topic.asp?tid=1842 to really complex stuff. Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Text File Directly to an Array | Excel Programming | |||
can i import barcode data directly to excel | Excel Programming | |||
How to import Yahoo historical data directly into spreadsheet? | Excel Discussion (Misc queries) | |||
Past directly into TextBox on UserForm | Excel Programming | |||
Code to edit directly in cells from userform | Excel Programming |