Unable to save xml from macro enabled excel file (.xlsm)

[Kruti1006]

Dear Team,

I am using pre-defined macro enabled excel file which has "SAVE XML" button. However, when I press this button I am not able to save this excel file in xml format. I am getting error -

Run time error '-2146232576 (80131700)' :
Automation error

Need urgent help

[#2]

@Kruti1006 Perhaps you'll find an answer here:

https://clearithere.wordpress.com/2020/03/20/solved-run-time-error-2146232576-80131700-automation-er... 

or here:

https://www.youtube.com/watch?v=hlaFjoZD8uc