Addin Question

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

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
 
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.
 
No, you can run it directly like so

Application.Run "addin_name.xla!macro_name"


--

HTH

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