Results 1 to 6 of 6

'Code Library' for VBA snippets

This is a discussion on 'Code Library' for VBA snippets within the General Excel Discussion & Other Questions forums, part of the Question Forums category; Hello All, Over the years I have been collecting useful bits of VBA for use in Excel, Word, etc. Currently ...

  1. #1
    Board Regular
    Join Date
    Jun 2005
    Location
    Adelaide, Australia
    Posts
    93

    Default 'Code Library' for VBA snippets

    Hello All,

    Over the years I have been collecting useful bits of VBA for use in Excel, Word, etc.
    Currently I use a Word document where Heading 1 is used for the application type and Heading 2 is for the snippet of code title. This allows me to create a table of contents for quick reference.
    The Word document also allows me to use a preamble about what the code does and then includes the code snippet.

    I have searched various forums and found a confusing range of information, then I found a post on Daily Dose of Excel http://www.dailydoseofexcel.com/arch...ode-libraries/ that was of some use but provided limited information.

    I would like to know:
    1. What others use
    2. What is available
    3. What could be carried on a USB stick and used on other computers without requiring anything to be installed on that computer.
    Thanking you in advance for any comments that may be provided.

    Regards,
    Dave

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    East Sussex
    Posts
    22,862

    Default Re: 'Code Library' for VBA snippets

    I used to use the Code Librarian that came with the Developer Editions of Office but after changing jobs, and not being allowed to install my own software any more, I just tend to use add-ins and Personal.xls as my libraries now; makes it fairly easy to carry them around on flash drives too.

  3. #3
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,198

    Default Re: 'Code Library' for VBA snippets

    Like Rory, I have a few workbooks and databases that hold relevant code. I have also exported modules as text files and then loaded a folder of exported modules onto a USB key. That's about as compact as you're likely to get.

    Denis
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

  4. #4
    Board Regular Darren Bartrup's Avatar
    Join Date
    Mar 2006
    Location
    Nottingham (UK)
    Posts
    1,008

    Default Re: 'Code Library' for VBA snippets

    I use a couple of things.

    Tiddlywiki is a single html page, but has a lot of Wiki type functionality (http://www.tiddlywiki.com/)
    I also save alot of .bas files so I can just drag and drop into my projects.
    Using Office 2003, 2007 & 2010,

    I'm 1 of the 10 people that don't understand binary. Guess that means the other 1001 do.

    No answer to your post?
    Get someone to read it - does it make sense or does it sound like gibberish?

  5. #5
    Board Regular
    Join Date
    Nov 2007
    Posts
    365

    Default Re: 'Code Library' for VBA snippets

    Great thread Exceler's,

    I use Notepad++, once you download some addins, you can get it to open in your default folder, which I set to be a VBA snippets library of bas modules. You can download this superb open-source software from the following website:

    http://notepad-plus.sourceforge.net/uk/download.php

    I also just found this site as well:

    http://www.garybeene.com/gbware/gbcodelib.htm

    Has anyone tried this software. It is free for non-commercial use.

    Delmar, using Tiddlywiki is a brilliant idea, saves having to carry around code all the time. Cheers,

    Also, Rory, can the "Code Librarian" for Office be freely downloaded from somewhere?

    Any other free software or ideas for stroing VB or VBA snippets?
    Last edited by exceluser2007; Jun 11th, 2009 at 02:23 AM.

  6. #6
    Board Regular
    Join Date
    Jun 2005
    Location
    Adelaide, Australia
    Posts
    93

    Default Re: 'Code Library' for VBA snippets

    Thank you all for the replies as it was interesting to see what others use.

    exceluser2007... A guy at work has produced a portable version of Notepad++ that enables me to save various bits of code. Not being all that familiar with Notepad++ yet so I am not sure if I can add comments to support the code entry.
    Would you be able to let me know what were the addins you downloaded for Notepad++

    I have had a quick play with Gary Beene's "gbFlashLib" which looks good and is very easy to use.

    Being new to VBA I find my Word document useful as it allows me to write a description of what the code does, where it goes, etc.

    I was just curious if there was any other portable way of carrying aroung code.

    Thank you to all for your replies.

    Regards,
    Dave T

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com