Page 1 of 2 12 LastLast
Results 1 to 15 of 29
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Advanced Find (W97)

    We have started using the 'category' field in document properties to identify various types of templates when global amendments are to be made, and successfully used Advanced Find to find these. However, although the search happily found 60-odd templates with the appropriate category, when I select around a dozen or so and clicked Open, Word only opens three or four then stops. Yet I can select twenty or more in Explorer and they will all open together quite happily. Having edited those and closed them, to open more, I have to run the search again - I saved the parameters, so setting it up is easy enough, but it takes quite a while to run.

    Does anyone know (1) how I can get Word to open more at a time (or just why it's not so far) and (2) if it's possible to save the results of a search, or keep it in the background so I don't have to run it again everytime?

    Many thanks in advance
    Beryl M


  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Advanced Find (W97)

    Is there any code (macro, that is, VBA) in any of these templates?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Advanced Find (W97)

    Yes, but only a max of a dozen lines, and in most cases just the names of two or three subs called from the normal.dot. Could this make a difference?
    Beryl M


  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Advanced Find (W97)

    I think this comes about as a result of the Word macro checking.

    I've had trouble with this before- but, because I've been able to get around it via Windows Explorer, I haven't worried too much abou it.

    When the "Concept" virus- the first widely distributed Word macro virus, came out, MS released a macro to check if macros were open. I had trouble opening more than 4 or 5 documents through Word then. I hacked a little, and had a little success, but concluded it was too much trouble, so gave it up. (I didn't know very much about Word macros back then).

    Just as an experiment, disable macro security completely, and see if you can open more docs at one time. Just don't leave that setting turned on.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Advanced Find (W97)

    Thanks for the suggestion but, though I blush to admit it <img src=/S/blush.gif border=0 alt=blush width=15 height=15>, macro virus checking was already completely switched off.

    Also, I can open any number of docs normally, it's just when opening a selection from an advanced find window - it just behaves as if I've only asked it to open three, or sometimes four, when I asked for quite a few more than that!
    Beryl M


  6. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Advanced Find (W97)

    Just to be thorough:

    What are the names of these subs?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  7. #7
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Advanced Find (W97)

    'Fullletter' or 'Windowletter' (depending on whether it's to be put in a window envelope or not) and 'Finish' (puts in yours sincerely etc), in most cases. Some have a few lines for filling in variables where standard text requires it.

    How could these affect this, pls?
    Beryl M


  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Advanced Find (W97)

    With those names, there is no possibility that Word dialogs are being "intercepted". You're ok there.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  9. #9
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Advanced Find (W97)

    Beryl,

    You're talking about the Word Open dialog advanced find, right? Not Windows Explorer find?

    I know it's no consolation to you, but since I trap the Open dialog for document management purposes, we can only open 1 file at a time -- Word 97 does not support opening multiple files if you write your own Dialogs(wdFileOpen) dialog. FYI. I think you've stumped me.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  10. #10
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Advanced Find (W97)

    Oh, well, thanks for trying! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Beryl M


  11. #11
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Advanced Find (W97)

    You could use your own VBA code... see attached. Open document, enabling macros, and check out the procedure. Questions?
    Attached Files Attached Files

  12. #12
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Advanced Find (W97)

    Brilliant, 'jscher'! <img src=/S/grin.gif border=0 alt=grin width=15 height=15> With a bit of tweaking (to suit actual circumstances, nothing wrong with your code!) it did exactly what I wanted. I think I might add a selection box giving the available categories to choose from, but otherwise it's perfect.

    I also learned a few new things about VBA that I'm definitely going to remember ...

    Many thanks! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Beryl M


  13. #13
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Advanced Find (W97)

    Jefferson, I know this thread is a little ancient, but I would be grateful if you could cast your mind back.

    I am using the code you wrote for me and I need to tweak it a little, just so that I can search for templates that don't have anything in the category field. However, at the moment it complains if there is nothing in the field and crashes if I comment out the bit that complains.

    I've looked through to try to see what it is that doesn't like the empty field but I can't spot anything obvious ...

    Any help would be greatly appreciated!
    Beryl M


  14. #14
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Advanced Find (W97)

    I tried to figure out how to search for "category = blank" interactively, so that I could code it, and I don't see any way to do it. If you don't see one either, this would leave you with the arduous task of inspecting the categories for all documents "manually" in code. I think the threads on DSOfile would be relevant to how to do this.

  15. #15
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Advanced Find (W97)

    Oh, well. Thanks for trying! <img src=/S/sigh.gif border=0 alt=sigh width=15 height=15>
    Beryl M


Page 1 of 2 12 LastLast

Posting Permissions

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