+ Reply to Thread
Results 1 to 3 of 3

vba Print Search Results

  1. #1
    Valued Forum Contributor
    Join Date
    11-15-2007
    Location
    England
    MS-Off Ver
    Office Pro 2003 / 2010
    Posts
    423

    vba Print Search Results

    Hi,

    I am told that it is not possible to print the search results for Office 2003, but it can be done with a macro.

    Could anyone help on this please?

    I want to seach for any files on the J:\ drive including subdirectories and folders for any zip files so *.zip.

    Thanks

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: vba Print Search Results

    Hi timbo1957,

    See the attached file. It probably does what you want and more.

    -------------------------

    The original attachment generated a runtime error when opened as a .xls file in Excel 2007 and later versions. The attachment was replaced on 01/31/2014.

    As a workaround,to use the previous attachment in those versions of Excel open the file. Save the file as a type .xlsm file.

    Lewis
    Last edited by LJMetzger; 01-31-2014 at 11:01 AM. Reason: Replaced attachment due to 2007 runtime error. Thank you mc84excel for the fix. Lewis

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: vba Print Search Results

    See the following post for the file in post #2 with the API declarations updated for Win64. The new file has NOT been tested using Win64.
    http://www.excelforum.com/excel-prog...ml#post3952011

    Lewis

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Display search results inluding results that match patrially
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2013, 08:52 AM
  2. Linking Search Results from an existing search macro
    By mougiasm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2013, 04:15 PM
  3. Macro to search, sum and print values results in run time error 91
    By KHudson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2011, 12:54 PM
  4. [SOLVED] I cant do a search on this forum. Everytime I search, it comes up with zero results
    By viswanthank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-10-2005, 05:05 AM
  5. [SOLVED] Print the results of a search
    By Celestina in forum Excel General
    Replies: 1
    Last Post: 01-11-2005, 10:06 PM

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