Creating Excel VBA Add-Ins

[poleary2000]

All,

This forum is great! I have been able to vastly increase by knowledge of VBA through asking questions and reading other posts.

From this board, I have obtained a bunch of useful snippets of code that do some really cool things. Is there a way I can create an add-in that would allow me to use these tools in any workbook? Sort of like PUP. I use a lot of these tools quite often and would like to find a way to use them easily.

Suggestions anyone?

 

[Jim North]

Check this out:

http://groups.google.com/groups?hl=...ta=group%3Dmicrosoft.public.excel.programming

 

[poleary2000]

So...the easiest way is to create an Excel Workbook that has modules containing the code I would like to reference. Then, create a toolbar that would link to the code.

Then, save the workbook as .xla. Put it in the startup folder and I should be good right?

Patrick

 

[Jim North]

See:

http://www.j-walk.com/ss/excel/tips/tip45.htm

also... compile your VBA code

 

[Jim North]

... and if this is for your personal use only, you could store it in your personal.xls... it is a "reserved" workbook in Excel.

 

[poleary2000]

Can you explain more about personal.xls?

 

[poleary2000]

Compile my VBA code?

 

[Jim North]

compiling VBA... when you are in VBE (visual basic editor) click on DEBUG... the first item on the drop down menu is COMPILE.

Regarding PERSONAL.XLS, it is a "hidden" workbook that Excel reserves for you. It's intent is for you to store common macros. One place you can see it is when you record a macro... it asks "Store macro in"... one of the options is Personal Macro Workbook.

 

[poleary2000]

What does compiling do for me?

 

[Jim North]

Read this:

http://groups.google.com/groups?hl=...ta=group%3Dmicrosoft.public.excel.programming