0

When trying to create a XML map in excel I get the error 1B6: (Add-Ins Tab -> XML Tools -> Select Convert range to XML -> click OK button)

fnMapRangeWithXml window which states 

 ERROR 1B6: Object doesn't support this property or method

I have saved it before as an XML from excel, and had gotten any errors.

*Relevant for both 2007 and 2010 version of Excel.

Improve this question

1 Answer 1

Reset to default
0

  1. In the Add-Ins tab in Excel.

    Select XML Tools -> Select Convert range to XML List -> Change the range which was selected -> click OK button

    Do this again (Add-Ins -> XML Tools -> Convert to XML)

    This time select the range you actually need Click OK. This should resolve the error.

  2. Another option is to copy the worksheet to another worksheet and then map from the new worksheet.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.