PC Review


Reply
Thread Tools Rate Thread

Creating ListObject using an XmlMap datasource.

 
 
=?Utf-8?B?Q2hyaXMgQ2Fwb24=?=
Guest
Posts: n/a
 
      4th Oct 2006
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(xlSrcXml, m, True, xlNo, r)

* The above code produces "Invalid procedure call or argument".

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating an ODBC datasource Sherwood Windows Vista Administration 1 4th Jun 2008 02:26 PM
ListObject does not update DataSource when cell value changes Sébastien Gillet (EzGlobe.com) Microsoft Excel Programming 0 2nd Apr 2008 10:03 PM
Creating PDF file out of XML datasource Puneet Microsoft ADO .NET 1 6th Jun 2006 03:34 PM
Creating PDF file out of XML datasource Puneet Microsoft VB .NET 2 29th May 2006 06:16 AM
Q: Creating a table within the datasource Geoff Jones Microsoft VB .NET 2 27th Jul 2004 01:40 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:59 PM.