Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help in adding XML maps to a worksheet using a script
I have been trying to use a script to build, map and populate worksheet in Excel 2003 with a .XML doc and a .XSD map. I have not been able to mimic in a script what excel does when mappin elements to the worksheet using drag & drop. The record marco comman does not record anything on this d & d function. When using d & d t map elements, it groups these columns together (blue border aroun perimeter of all the mapped elements/columns), but using the belo script it creates separate column lists for each column (separate blu border around each column). This in turn makes it impossible t export it back to .XML document, getting error when using the "View ma for export" command. Here is the script I use for mapping the elements to each column. Bu like I said it maps them as separate Column Lists, a new 2003 feature. 'Map elements into spread sheet strXPath = "/PowerShift/C1A/Customer_number" Set xp = worksheet.Range("A1:A2").Offset(1,actColumn).XPath xp.SetValue workbook.XmlMaps(1), strXPath actColumn = actColumn + 1 'Map elements into spread sheet strXPath = "/PowerShift/C1A/Customer_type" Set xp = worksheet.Range("A1:A2").Offset(1,actColumn).XPath xp.SetValue workbook.XmlMaps(1), strXPath actColumn = actColumn + 1 How do I map the elements so they don't appear as separate colum lists? Thanks, Rober -- robl ----------------------------------------------------------------------- roblo's Profile: http://www.excelforum.com/member.php...fo&userid=2246 View this thread: http://www.excelforum.com/showthread.php?threadid=39866 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Script - Create New Worksheet | Excel Discussion (Misc queries) | |||
getting data from excel worksheet in to a script | Excel Discussion (Misc queries) | |||
VB script for converting each worksheet into individual pdf files. | Setting up and Configuration of Excel | |||
Adding time to script | Excel Programming | |||
Excel 2000/XP script to Excel97 script | Excel Programming |