When I import web data into a sheet using the VBA XMLImport method in Excel 2007, the user gets a pop up window on the spreadsheet which says "Choose the XML Map to use for this import". The window lists the three maps I've created in the workbook. If you pick the right one, the import completes normally.

But I specified the correct map name in the XMLImport statement using the ImportMap parameter. Why is Excel asking for the map name again???? If you only have one map in the workbook, it will use that map and not ask. But if you have more than one, the user has to select the correct map or cancel the import. Heeeellllllp!