Re: How to modify the VBA componants remotly?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: rakesh jain (rakesh_at_yahoo.com)
Date: 08/26/04 

Date: Wed, 25 Aug 2004 22:43:34 -0700

Jezebel,
My file is so big due to the thousands of records entered in various
sheets. But I belive main reason for bigger size is the vigorious use of
VLOOKUP formula in all sheets.
Also 6 pivot tables created for different reports further increases the
size. I do not have code to zip the file. I use winzip from windows
explorer to zip the file manually.

I need a code which can replace the code modules and userforms of
existing file with a new updated ones.

I have heard that almost every thing is possible with VB. Can you pl
guide me with a sample code or atleast some pointers?

Regards,
Rakesh.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Quantcast