Build a VB .Net project to decrease excel file size


New member
Feb 23, 2005
Programming Experience
Hi, I always have the problem when editing a Microsoft Visual Basic for Applications macro using the Visual Basic Editor. The more the code is edited, the larger the file size becomes.

Then I found a solution from here.;en-us;264907

Then I want to build a .exe tool with File Browser, so that I can export/import all macros, resave them to decrease file size.

I chose VB .Net. My file browser was completed, and I created a button to call the function in the above link. But the compiler could not compile at the declaration of VBComponent. I added the reference MS Visual basic Extensionbility 5, as I did in VB Editor, but problem exists.

I know nothing about VB .Net. Thanks for your advice.
Last edited:
Top Bottom