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

%3CLINGO-SUB%20id%3D%22lingo-sub-2019541%22%20slang%3D%22en-US%22%3EUnable%20to%20save%20xml%20from%20macro%20enabled%20excel%20file%20(.xlsm)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2019541%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Team%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20pre-defined%20macro%20enabled%20excel%20file%20which%20has%20%22SAVE%20XML%22%20button.%20However%2C%20when%20I%20press%20this%20button%20I%20am%20not%20able%20to%20save%20this%20excel%20file%20in%20xml%20format.%20I%20am%20getting%20error%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERun%20time%20error%20'-2146232576%20(80131700)'%20%3A%3CBR%20%2F%3E%3C%2FSPAN%3EAutomation%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENeed%20urgent%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2019541%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2019672%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20save%20xml%20from%20macro%20enabled%20excel%20file%20(.xlsm)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2019672%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F913341%22%20target%3D%22_blank%22%3E%40Kruti1006%3C%2FA%3E%26nbsp%3BPerhaps%20you'll%20find%20an%20answer%20here%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fclearithere.wordpress.com%2F2020%2F03%2F20%2Fsolved-run-time-error-2146232576-80131700-automation-error-in-excel%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fclearithere.wordpress.com%2F2020%2F03%2F20%2Fsolved-run-time-error-2146232576-80131700-automation-error-in-excel%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eor%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DhlaFjoZD8uc%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DhlaFjoZD8uc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply