XML export with Excel vba code

Question

I would like to ask if it's somehow possible to include some vba code in an XML file?

After an export of my excel file to xml I cannot see it.

My goal is to create excel with macros from xml.

Carrosive · Accepted Answer · 2016-05-18 10:35:28Z

1

I think you may be getting confused between saving an XML Data file and an Excel Add-In (you may have seen this called an XML Add-in).

By using Save As and selecting the XML Data file type, Excel will produce an XML file with the data contained only on your worksheets and so no VBA is saved. An Excel Add-In though is a file containing macro information so you can quite easily add the macros it contains to another installation of Excel, I believe this is the goal you are trying to achieve.

This webpage helped me a lot when I first learned how to create add-ins, and it also includes information on creating custom ribbon UI's for your macros; And this webpage contains instructions on adding / removing Add-ins.

answered May 18, 2016 at 10:35

Carrosive

9092 gold badges10 silver badges25 bronze badges

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

2 Comments

Acla Over a year ago

Unfortunately this excel add-in is not working with 64-bit.

Carrosive Over a year ago

@Acla can you elaborate on that with a specific error message? I'm guessing that your specific macro is 32-bit and you're trying to add it to a 64-bit installation of Excel? Try adding PtrSafe after any Declare statements

Collectives™ on Stack Overflow

XML export with Excel vba code

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related