Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I used a file viewer to examine an XLA add-in that I created, and I can still see the comments I inserted into my VBA code. Doesn Excel remove these comments before creating an XLA file?

April 26, 2017add-in comments examine file inserted Used VBA viewer XLA

0

Posted

I used a file viewer to examine an XLA add-in that I created, and I can still see the comments I inserted into my VBA code. Doesn Excel remove these comments before creating an XLA file?

1 Answer

0

Posted

No. The comments and spaces remain in the XLA file, making it larger than it need be. To make your XLA file as small as possible, you should remove all comments, extra spaces, and blank lines from your VBA code before creating the add-in. And to compact your file even further, you should copy the code in your modules, delete the modules, insert new modules, and then paste the copied code to the new modules.