Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
read xml method-- faster one
Dear all,
Is it possible for ADODB.Recordset to read xml in excel?? I have followed the code below but it prompt error when recordset open. Error Message"???????? ??XML??????". Do you know why??? http://www.ozgrid.com/forum/showthread.php?t=27818 Moreover, Is it possible to use xmltextreader in excel vba?? All I want to do is speed up searching a record in xml file. Now I have done according to below. But it need iterate for each record. http://msdn.microsoft.com/en-us/libr...ffice.10).aspx Any Ideas in excel vba??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
read xml method-- faster one
Try instead of Excel 8.0 use XML 1.0. XML is not an excel format and is
probably confussing. An XLS file is binary and XML is text which would be a problem. "rchiuhk" wrote: Dear all, Is it possible for ADODB.Recordset to read xml in excel?? I have followed the code below but it prompt error when recordset open. Error Message"???????? ??XML??????". Do you know why??? http://www.ozgrid.com/forum/showthread.php?t=27818 Moreover, Is it possible to use xmltextreader in excel vba?? All I want to do is speed up searching a record in xml file. Now I have done according to below. But it need iterate for each record. http://msdn.microsoft.com/en-us/libr...ffice.10).aspx Any Ideas in excel vba??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
faster method to delete rows | Excel Programming | |||
For each cell method, is there a much faster way? | Excel Programming | |||
Which method is faster | Excel Discussion (Misc queries) | |||
Looking for faster method for Copy & Paste | Excel Programming | |||
Which method is faster? | Excel Programming |