Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating ListObject using an XmlMap datasource.
Is it possible, using VBScript, to create a new ListObject using an XmlMap as
the data source? This can be done in the UI, but not seemingly through code. eg: Dim m as XmlMap Dim l as ListObject Dim r as Range Set r = ActiveWorkbook.ActiveSheet.Range("A1") Set m = ActiveWorkbook.XmlMaps("Sample_Map") Set l = ActiveWorkbook.ActiveSheet.ListObjects.Add(xlSrcXm l, m, True, xlNo, r) * The above code produces "Invalid procedure call or argument". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ListObject binding | Excel Programming | |||
import xml using xmlmap WITHOUT linking to list | Excel Programming | |||
Excel.xmlMap not defined | Excel Programming | |||
Events for listobject | Excel Programming | |||
listobject ... Excel2003 | Excel Programming |