I have created a macro to automate the production of test specifications in
excel.
The problem is that it has become so large that that a blank document (no
user tests) is in excess of 600Kb already and its not even finished yet.

Some of our department have problems opening large files so what I would
like to do is find some way to be able to run the macros needed without
having them embedded in the actual sheet. Hence each working document is much
smaller in size but still has the exact same functionality.

Is this possible? If so does any one know how to do this?

Try this thread:

http://groups-beta.google.com/group/...c45630063c2e33

Thanks Michael,

From looking at other threads I'd found something like you mention, but the
problem is when I try to run it I get
"Run Time Error 1004 Application defined or object defined error"

How do I fix this?


"Michael Malinsky" wrote:

Try this thread:

http://groups-beta.google.com/group/...c45630063c2e33

Michael,

Thanks for your help I have now figured it out, an its made a big difference
- a blank document is now 2/3 smaller than my old file with the macro embedded

"Michael Malinsky" wrote:

Try this thread:

http://groups-beta.google.com/group/...c45630063c2e33