Build a VB .Net project to decrease excel file size

wanda46

New member
Joined
Feb 23, 2005
Messages
1
Programming Experience
Beginner
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.
 
Last edited:
Top Bottom