Results 1 to 9 of 9
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update to name manager (97 2000 2002)

    Hi all,

    Just uploaded a new version of my Name manager.

    Fixed a small bug regarding the localisation of global names.

    Find it here:

    http://go.compuserve.com/MSOfficeForum?SEC=9&FID=3858

    (click the Guest button if you're not registered over there)

    Somewhere this week also available on The Excel MVP page listed below.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  2. #2
    Lounger
    Join Date
    Jan 2001
    Location
    Basalt, Colorado, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update to name manager (97 2000 2002)

    Jan,
    Works great, have not found any problems.
    I do have one "Wish List" item though...
    Would you consider changing the "Is Used" button, so it would also detect when a name is used in a hyperlink?
    (I use hyperlinks to named cells for easy navigation in large sheets)

    If not, I still love the program and really appreciate such a great utility.

    Thanks,
    Dan Arbaney

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update to name manager (97 2000 2002)

    Thanks! Treid it and found its data is May 7th and the build# is 396. Checked my current one (which I got a few weeks ago and that's the same one)...

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update to name manager (97 2000 2002)

    As it is right now, only cells are checked for presence of a name. This is a lengthy process, since I need to make sure the "hit" is exact: If I am searching for TheName, I DON"T want to find TheName2. SO I need to check each and every hit against the characters that precede and follow the found occurance and decide whether they may belong to a valid name or not, thus deciding if I really did find the name I was looking for.

    That being said, I am developing a new release of my flexfind utility, which does search in objects to find strings. You could use that to search in hyperlinks.

    Would you like to test it?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    Basalt, Colorado, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update to name manager (97 2000 2002)

    Jan,

    I would be happy to.

    Thanks,
    Dan Arbaney

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update to name manager (97 2000 2002)

    Here it is!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Lounger
    Join Date
    Jan 2001
    Location
    Basalt, Colorado, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update to name manager (97 2000 2002)

    Jan,
    I tried build 513 of flexfind, but had no success finding anything in comments, drawing objects, or hyperlinks.
    See my attached 'flextest.xls'.

    Thanks,
    Dan

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update to name manager (97 2000 2002)

    The file you attached cannot be opened by winzip.

    Did you check the "Objects" checkbox?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    Lounger
    Join Date
    Jan 2001
    Location
    Basalt, Colorado, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update to name manager (97 2000 2002)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15> Jan,
    D' oh!
    Appartentlyt I had not checked "objects", because now it seems to work just fine.

    Sorry for the inconvenience.
    Not sure why winzip couldn't open the file. I use a freeware zip program, it could be you get what you pay for.

    I will continue to try out flexfind.

    Thanks,
    Dan Arbaney

Posting Permissions

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