Mickey

I find that saving the examples in an Add-in that I load with Excel works for
me.

Just create a new workbook and ALT + F11 to go to Visual Basic Editor.

CTRL + r to open Project Explorer.

Select your workbook/project and insert a few modules.

Save the snippets in appropriately named modules and they are always available
for all workbooks and for copying/testing/editing/exporting as *.bas files or
whatever.

FileSave AsFile TypeAdd-in(*.xla)

I even try to to remember to attribute the snippets to the originator using
comments in the code.

But in my haste to "snippet" I sometimes forget the attribution.

Apologies to all for this neglect.


Gord Dibben Excel MVP


On Mon, 2 May 2005 23:23:55 +0100, "MBlake"
wrote:

Hi,
When I am working on my websites I save 'snippets' of code for use
elsewhere. These 'snippets' are quickly called from the software
(Dreamweaver). There are tons of great posts here and I am sure that many
of the code examples can be used elsewhere. Is there a way to store
snippets' in Excel or is it a case of keeping Notepad files in a folder?.

Mickey