I have a project im working with right now, and the file sizes are muc
too large. I have a considerable about amount of data in th
spreadsheet and a lot of VBA code.

So I was wondering if there was a way to write code to remove the cod
in the spread sheet. I would much rather remove the modules and wha
not than to have to copy this data to another spreadsheet

--
Message posted from http://www.ExcelForum.com

Hi Cory

Try the examples on Chip's site
http://www.cpearson.com/excel/vbe.htm

Also check out this
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Cory Thomas " wrote in message ...
I have a project im working with right now, and the file sizes are much
too large. I have a considerable about amount of data in the
spreadsheet and a lot of VBA code.

So I was wondering if there was a way to write code to remove the code
in the spread sheet. I would much rather remove the modules and what
not than to have to copy this data to another spreadsheet.


---
Message posted from http://www.ExcelForum.com/

Can't you just right click on each module in the project explorer (VBE) and
remove the modules?

Anyway, Chip Pearson has such code at his site:

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

"Cory Thomas " wrote in message
...
I have a project im working with right now, and the file sizes are much
too large. I have a considerable about amount of data in the
spreadsheet and a lot of VBA code.

So I was wondering if there was a way to write code to remove the code
in the spread sheet. I would much rather remove the modules and what
not than to have to copy this data to another spreadsheet.


---
Message posted from http://www.ExcelForum.com/

Thanks for the links, i used Chip's method.

The reason i cant just right click and remove them is because im no
going to be running this spreadsheet. It is going to be run about 8
15 times a day. I dont want to make the people running the macro t
have to manually delete them to make the file size 50% smaller.

Anyways, thanks again for the link

--
Message posted from http://www.ExcelForum.com