View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default VBA Code to remove VBA

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/