Thread: Assign xml map programmatically
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Stubbs David Stubbs is offline
external usenet poster
  
Posts: 1
Default Assign xml map programmatically
With the XML Source panel open (Data-XML-XML Source...), I can drag a map
onto a sheet, e.g., dataroot to A1.

When I try recording this action as a macro, the macro is empty.

How can I programmatically (vba6) associate a map (e.g.,
ActiveWorkbook.XmlMaps("dataroot")) with cell A1?

Thanks very much!
--

David Stubbs -- Usability Architects, Inc.
2215 NE 45th Ave
Portland OR 97213-1343
+1.503.284.0164 Portland Office
+1.425.827.9296 UAI Kirkland
http://www.usability-architects.com

Reply With QuoteReply With Quote