Some Links

The blist beta opened this week and I got an invite. I think I signed up for it last November. I really like the things that I can put in fields, such as images, lists, URLs, and even other tables. There are three things that weren’t immediately discoverable by me: I don’t know how to relate two tables; I don’t know how to make a calculated field; I don’t know how to tell them what I think.

Blist launched at Demo ’08. I watched some of the presentations yesterday. That site must use ActiveX because it wouldn’t work in Firefox. There were a few interesting ones and a lot that solved “problems” that I’ve never had and can hardly conceive.

I’m not sure if I’ve mentioned this before, but xldennis release .Net Co.

With the tool you can:

* Store created VBA code, code snippets / procedures / modules, and SQL Queries in a well organized way enabling you to easily reuse the code in all kind of Excel VBA solutions.
* Create connection strings to a various number of databases with two wizards, the .NET Wizard and the Data Link Wizard. Store the created connections strings in a structural way enabling you to easily reuse the connection strings in all kind of Excel VBA solutions.

.NET Co Library has been designed so it also can be shared within a group of VBA developers over a network.

I don’t use a code library, I just open a previous project and copy what I need. But I’ve often wanted to use one to be more organized about it. I’m going to try this one out and see if I like it.

Last night I downloaded agilegraph. It claims it will turn my spreadsheets into interactive graphs. I’m not much of a charting guy, but I’m interested to see how it works. I had to download .Net 2.0 to install it. I can’t believe I haven’t needed 2.0 for anything yet.

Posted in Uncategorized

6 thoughts on “Some Links

  1. Interesting to hear that there are still some people who don’t use any kind of code/snippet library. I couldn’t live with mine, but I’m starting to doubt whether I only use the tools I use because I’m used to them.

    I use MZ-Tools for snippets, and a Subversion repository for my classes. I realize the latter is an overkill, but all the sources my apps under development and in production are in there, and I can access it from home and work just the same, so it works for me.

    How do you guys keep your code libraries?

  2. I use Windows Explorer as my code library. I have probably thousands of saved emails, newsgroup posts, text files, web pages, modules, workbooks, image files, etc., which reside in a labyrinthine directory hierarchy. Sometimes, I even just open a workbook or add-in that I know uses the snippet I want. Lately it seems that I often go to Google before diving into my own code maze. It sounds pretty bad, but it isn’t really.

  3. Jon Peltier wrote:
    I use Windows Explorer as my code library. I have probably thousands of saved emails, newsgroup posts, text files, web pages, modules, workbooks, image files, etc., which reside in a labyrinthine directory hierarchy. Sometimes, I even just open a workbook or add-in that I know uses the snippet I want. Lately it seems that I often go to Google before diving into my own code maze. It sounds pretty bad, but it isn’t really.

    I use the same techniques, although for some time now I’ve been thinking of getting a “real” tool with better code management capabilities. Now that Dick has put the issue back into my consciousness, I’ll check out Dennis’s library.

  4. I used the Code Library in the Office XP Developer edition for a while, but it tended to be unstable and was quite large.
    Currently I have a 170 sheet XL workbook with a hyperlinked table of contents and a toolbar button activated list box with all of the sheets listed…
    from ADO to XL2007. I can manage to find stuff in it, but a cross reference system of some sort would be nice. It is about 1/2 the size of the Developer
    edition Code Library, but still takes it own sweet time to save.
    It is not something I want to lose, so a backup is automatically made, when the file is closed, to a separate partition.
    Even with the above, it is ofter easier to look in the manila file folders containing code print outs from various programs I’ve written.
    Whatever works for you.

  5. Hello:

    After many hours searching the web, I found your 2004 Automating Internet Explorer posting on how to download all the hyperlinks from a webpage. Unfortunately, I cannot find the Microsoft Internet Controls Reference. It’s no longer supported – from what I can gather.

    What else do you suggest?

    This is what I am attempting to accomplish:

    1. Download links from the main site.
    2. Based on key word of physician open the physicians directory page and download list of specialities.
    3. Click on each speciality hyperlink which will then take me to a list of doctors. Download this hyperlink list.
    4. Then, click on each physician hyperlink and download phyiscian bios in csv or xml format.
    5. When done go back to the list of specialities and repeat the process until I have downloaded all of the information.

    Any help would be much appreciated!

    ADR


Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published. Required fields are marked *