+ Reply to Thread
Results 1 to 3 of 3

export find results

  1. #1
    Amir
    Guest

    export find results

    is there a way to export the results of the 'find' query to a notepad or a
    new excel sheet)

  2. #2
    Duke Carey
    Guest

    RE: export find results

    I expect that the only way to do that would be through VBA. If you press
    Alt-F11 from Excel you'll go to the VBA editor. Go to Help and look up the
    Find method and view the topic as it relates to a Range object. There is
    example code included that cycles through every instance that Find locates.
    You could cobble that code together with some other code to write the results
    to a text file.


    "Amir" wrote:

    > is there a way to export the results of the 'find' query to a notepad or a
    > new excel sheet)


  3. #3
    Jan Karel Pieterse
    Guest

    Re: export find results

    Hi Amir,

    > is there a way to export the results of the 'find' query to a notepad or a
    > new excel sheet)


    If you download my "Flexfind" utility, you can use it's "List" button to do
    just that:

    www.jkp-ads.com/OfficeMarketPlaceFF-EN.htm

    Regards,

    Jan Karel Pieterse
    Excel MVP
    http://www.jkp-ads.com


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1