Xml Mapping in Excel Macro

Hi Team,

I am working on a macro development where user will key in all the entries in sheet 1 and I have done my xml mapping in the same sheet to export the table contents as a xml file.

There are few columns in the sheet1 which by default I know what value should come and I don't want User to key in the values. So I thought of putting those columns in sheet 2 , still map those columns to the same xml mapping.

But in this case I could not export the xml it throws me an error as below

An XML mapping cannot be exported if the mapped element's relationship with other elements cannot be preserved.

Kindly advise how I can achieve this.

Regards
Dhivya

Hi Team,

Any inputs on my above query?

Regards
Dhivya