Problems with ActiveWorkbook.XmlImport & ImportMap

I've been working on a script that auto-creates a new *.xlsx workbook, imports the XSD map, and imports an XML file. I've just about worked out the bugs to have it use the new file and format the data as needed, then it filters out data based on vendor (I have a list of 52 vendors - and this part works beautifully), dumps the mined data to a new workbook, saves, closes, and continues.

The problem I'm having is the map does not auto-import. It fails to import the map and data.

Please Login or Register  to view this content.

Here's my XSD Map:

Please Login or Register  to view this content.

you don't appear to be specifying an xmlmap in that method-you specifically use Nothing for the importmap argument. have you already added the map to the workbook's xmlmaps collection?

That's where the problems begin. I tried using the ImportMap:="vendordetails_Map", but is errors out with a compile error message.

I also tried it like this

Please Login or Register  to view this content.

you'll need to use xlmmaps.add before you import the xml

Ok,

Should the code look more like this?

Please Login or Register  to view this content.

I'm just not sure where I'm going wrong here.

I reckon it oughta be more like

Please Login or Register  to view this content.

thanks! I just tried your script, but it hangs on the Set oMap line.

The error message is: Run-time error '91': Object variable or With block variable not set

I've been given another option, but it didn't seem to work either...

Please Login or Register  to view this content.

This script hangs on the last line with the same error message.

can't see the problem-the code works here using your xsd file