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.
http://support.microsoft.com/default.aspx?scid=kb;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.
Then I found a solution from here.
http://support.microsoft.com/default.aspx?scid=kb;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:
