Addin Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 30 Dec 2004 18:41 GMT

Hi,

Each week we distribute an Excel file that is auto generated from a
database and which is several MB in size. I have identified that the size
is due to the mass of unused rows and columns and when deleted, the file
size is c. 100kb.

I have found VBA code that will removed the unused cells and would like to
add as an Addin. However, having saved the file containing the code, and
loading as an Addin, I can't find reference to run the code.

Do I need to add menu items or something?

Thanks, Rob

Reply to this Message

Ken Wright - 30 Dec 2004 19:28 GMT

All you generally have to do is select all columns after the last one containing
data, do CTRL + - (ie CTRL & minus key), and then do the same for rows below
your last. save the book and you are done.

Selecting is easy also, as for example if you wanted to delete all after Column
D you would select Col E by clicking on the header, then hold down CTRL+SHIFT
and hit the RIGHT arrow key. then do the CTRL + - bit etc.

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

> Hi,
>
[quoted text clipped - 10 lines]
>
> Thanks, Rob

Reply to this Message

Bob Phillips - 30 Dec 2004 19:32 GMT

No, you can run it directly like so

Application.Run "addin_name.xla!macro_name"

Signature

HTH

RP
(remove nothere from the email address if mailing direct)

> Hi,
>
[quoted text clipped - 10 lines]
>
> Thanks, Rob

Reply to this Message

Dave Peterson - 30 Dec 2004 23:08 GMT

John Walkenbach as a sample workbook that adds a bunch of routines to the
worksheet menu bar. He calls it MenuMaker.xls.

You can find it:
http://j-walk.com/ss/excel/tips/tip53.htm

> Hi,
>
[quoted text clipped - 10 lines]
>
> Thanks, Rob

Signature

Dave Peterson

Reply to this Message

Rob - 31 Dec 2004 08:29 GMT

Thanks for the pointers, happy new year, Rob

> John Walkenbach as a sample workbook that adds a bunch of routines to the
> worksheet menu bar. He calls it MenuMaker.xls.
[quoted text clipped - 18 lines]
>>
>> Thanks, Rob

Reply to this Message