Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reducing File Size - Turning VBA into txt?
I'm attempting to reduce the file size of my Excel document, it i
currently at a size of 12.2 Megs. The speed of the document doesn' really matter, but my company won't be happy to see how big it is especially considering the ENTIRE file will be replicated each week. know that the main issue is a number of lengthy macros. I have read on NUMEROUS matches from googling "excel file size" tha the main way to reduce your document by up to 50% is to go into VBA save a module as .txt, delete the module, then bring back the origina code and save normally. The problem I have is with saving the file a .txt. I simply do not have the option of SAVE AS, let alone .txt. I fact, I dont think I have a way to save the VBA code itself, in effec I'm really just saving the entire excel file, from within VBA?!? Mayb I'm access VBA wrong, but I typically go into Tools-Macros-Visual Basi Editor. I am using Office 2k. Anyone know what I'm doing wrong -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reducing file size | Excel Discussion (Misc queries) | |||
Reducing File Size | Excel Worksheet Functions | |||
reducing file size | Excel Discussion (Misc queries) | |||
Reducing file size | Excel Discussion (Misc queries) | |||
reducing file size when done | Excel Programming |