Results 1 to 8 of 8
  1. #1
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    MOD XP and Code Librarian (MOD XP, no SR)

    Has anyone figured out how to import a version 9.0 CodeLib database into Code Librarian 10? You can't open the earlier version, even though that's one of the file type options in the XP version. When you try, it comes back and tells you that you have to import the previous version file.

    So far, I have been completely unable to locate even the *word* import in the "help" associated with Office Developer/Code Librarian. I thought the Office 2000 help was bad, but XP has it beat! Nor have I been able to find even a smell of an import item on any of the toolbars or menus. <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> Is this something they just forgot to implement or has someone discovered the genie that grants your import wish???

    If anyone has figured out how, take pity on a <img src=/S/granny.gif border=0 alt=granny width=20 height=20> and spell it out for me, please. <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23> I love progress. <img src=/S/sarcasm.gif border=0 alt=sarcasm width=15 height=15>
    Charlotte

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: MOD XP and Code Librarian (MOD XP, no SR)

    Hi Charlotte,
    As far as I know, the only way to do it is through Access - opening up the codelib.mdb, linking to the tables and then appending the data (there may be a better way of doing that bit!).
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MOD XP and Code Librarian (MOD XP, no SR)

    You lost me, Rory. Linking to *what* tables? Appending which data to where? Are you talking about copying and pasting routines into the new version from the old? I've got 3.6Mb of code stashed in my personal version 9 CodeLib file, not the default one that came with it. I really don't want to have to paste that in to the new one a single routine at a time. <img src=/S/nope.gif border=0 alt=nope width=15 height=15>

    The latest version of Code Librarian implies that you can import the libraries from the previous version. The current version is a standalone program that uses files with a clb extension rather than the protected mdb files the previous version used. Are you saying that the libraries from version 9 are no longer protected using Access XP?
    Charlotte

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: MOD XP and Code Librarian (MOD XP, no SR)

    Sorry - I don't have XP and had foolishly assumed that the Code Librarian still used Access databases! (I take it you can't open the clb file in Access2002?) The version 9 libraries are protected but the password is just "CodeLib" so you can get the data out of them and move it around fairly easily!
    Sadly, after some fairly extensive searching I can't find anything more than that simple "you can import previous library versions" comment - no mention at all of how you actually do it!
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SOLVED-MOD XP Code Librarian (MOD XP, no SR)

    <img src=/S/scream.gif border=0 alt=scream width=15 height=15> I found it by accident!

    From the Code Librarian menu of the Microsoft DevelopementEnvironment, select Add-->Existing Library. Select Code Library V9.0 and point to an MDB and you'll get a dialog that says "This file is from an older version of CodeLibrarian. In order to veiw it you must import it into a new library." When you click on OK, you're back at a FileOpenSave common dialog.

    The difference is, that this time the Title bar of the common dialog says "Save As" and the file type is set to Code Library by default. If you then select a location, type in a file name and click on the Save button, it will create a new CodeLibrarian file for you from your mdb.

    Apparently it was just too obvious to add an Import item to the menu! <img src=/S/aflame.gif border=0 alt=aflame width=15 height=15> They must really dislike the entire word "import" because there is no mention of importing or converting an earlier version in the help or the MSKB.
    Charlotte

  6. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SOLVED-MOD XP Code Librarian (MOD XP, no SR)

    I installed Office XP yesterday. I noticed that the only Office Developer Add-Ins listed in the VBE are:

    Code Commenter and Error Handler Add-Ins
    Multi-Code Import/Export
    Packaging Wizard
    VBA Source Code Control
    VBA String Editor

    Code Librarian is not listed, it is available as a stand-alone via the MDE.

    I'm disappointed that the VBA WinAPI Viewer is not included in Office XP

    Charlotte, do you see the same?

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SOLVED-MOD XP Code Librarian (MOD XP, no SR)

    That looks right to me.

    Code Librarian isn't an add-in in Office XP as far as I can tell. I generally used it as a standalone in MOD 2000 as well, and I really prefer it that way. I didn't look for the API viewer because I prefer the API-Guide, downloadable from <A target="_blank" HREF=http://www.AllAPI.Net>http://www.AllAPI.Net</A> It is far better and more complete and includes comments and examples.
    Charlotte

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SOLVED-MOD XP Code Librarian (MOD XP, no SR)

    I agree that Code Librarian should be a stand-alone.

    I know about AllAPI.net, but I prefer to use a built-in viewer.

Posting Permissions

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