+ Reply to Thread
Results 1 to 17 of 17

Search Engine Macros in Excel

  1. #1
    Registered User
    Join Date
    04-07-2017
    Location
    india
    MS-Off Ver
    2007
    Posts
    10

    Search Engine Macros in Excel

    hello,
    I'am new to this coding so i need help in making my job easy in non technical field. so my problem statement is,
    In a "Folder A" I have all my docs..i need macro which would be mapped to "Folder A" path and the macro works as search tool so if i search name and if it matches any docs in that folder, resultant doc name should appear in cells.and can i make that cell as downloadable if u click on that cell\link the doc file should get download!!

    Please i need help on this as i have more than 800+ documents which needs to be referred before completing my work.

    thank you

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Search Engine Macros in Excel

    Hi
    is this roughly what you're after?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-07-2017
    Location
    india
    MS-Off Ver
    2007
    Posts
    10

    Red face Re: Search Engine Macros in Excel

    hello nicky,
    i tried attached excel sheet and replaced the file location to different location but even tough the file is present added with or without including document extension the search result showed "no".
    may i know what exactly i made mistake here and also can this file location mention can be a server location like centralized instead of local system.

    thank you so much for quick response and help!!

  4. #4
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Search Engine Macros in Excel

    hi
    as long as the file source is a conventional path it should be ok eg

    h:\myfolder\myfile.xlsx
    or
    c:\mydocuments\myfile.xlsx

    did you include a final "\" in the file path? If not, that could throw it

  5. #5
    Registered User
    Join Date
    04-07-2017
    Location
    india
    MS-Off Ver
    2007
    Posts
    10

    Re: Search Engine Macros in Excel

    hello nicky,
    i did as instructed and yes this is working like sweet, but small doubt the name of the file which i want to search should be given completely because when i tried like keyword search it showed error as "no" and i understood about conventional path but is it possible to make it server path so this can be used in bulk by other users just like search engine!!

    regards,
    Vivek

  6. #6
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Search Engine Macros in Excel

    Try

    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    Last edited by mike7952; 04-07-2017 at 05:50 AM.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  7. #7
    Registered User
    Join Date
    04-07-2017
    Location
    india
    MS-Off Ver
    2007
    Posts
    10

    Re: Search Engine Macros in Excel

    Hello mike,
    one last question!! please don't mind! i tried and everything is working as i expected and thank you very much! but can i make documents to open in new window instead of workbook!

    Regards and Thank you
    Vivek

  8. #8
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Search Engine Macros in Excel

    Are you trying to have multiple user using and modifying the workbook at the same time?

  9. #9
    Registered User
    Join Date
    04-07-2017
    Location
    india
    MS-Off Ver
    2007
    Posts
    10

    Re: Search Engine Macros in Excel

    hello mike,
    my intentions is work like as you said multi user!!

    thank you

  10. #10
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Search Engine Macros in Excel

    I'm not sure but I think Excel is not gonna let have multi users writing to the file at the same time. Now if one user has the file open another user can open the file "I think", but will be prompted that the file is in use and give the user an option to be Notified when the file is available, cancel or ignore.

  11. #11
    Registered User
    Join Date
    04-07-2017
    Location
    india
    MS-Off Ver
    2007
    Posts
    10

    Re: Search Engine Macros in Excel

    hello mike,
    thank you very much for your inputs!!
    much appreciated.

    thank you

  12. #12
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Search Engine Macros in Excel


  13. #13
    Registered User
    Join Date
    04-07-2017
    Location
    india
    MS-Off Ver
    2007
    Posts
    10

    Re: Search Engine Macros in Excel

    hi mike,
    can i do search as keyword search instead of giving entire name of the file!!

    Warm Regards
    Vivek

  14. #14
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Search Engine Macros in Excel

    Quote Originally Posted by vivekbr View Post
    hi mike,
    can i do search as keyword search instead of giving entire name of the file!!

    Warm Regards
    Vivek
    I'm not sure what you mean by a keyword search. What are you searching for?

  15. #15
    Registered User
    Join Date
    04-07-2017
    Location
    india
    MS-Off Ver
    2007
    Posts
    10

    Re: Search Engine Macros in Excel

    hello mike,
    for example in my D:\PDF\ folder i have documents files like Col_1, Col_2, Col_3, Col_4 and so on and other documents starting with word "C" so instead of typing entire name as "Col_3.pdf" can i just writ "Col" and expect result display of all documents whose name starts with "Col"??

    Regards

  16. #16
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Search Engine Macros in Excel

    Yes you can do that, where do you want these results displayed?

  17. #17
    Registered User
    Join Date
    04-07-2017
    Location
    india
    MS-Off Ver
    2007
    Posts
    10

    Re: Search Engine Macros in Excel

    hello mike,
    sorry for late reply! is it possible to display those results in same excel or new excel sheet cell after the cell, so when i try to open a document it displays the content!

    thank you

+ 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. Excel Search Engine
    By KingConga in forum Excel General
    Replies: 1
    Last Post: 09-02-2015, 01:54 PM
  2. Search Engine using macros - how to create?
    By Sylvanusfernandez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2014, 03:11 AM
  3. [SOLVED] Excel Search Engine
    By Enehasd in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-14-2014, 10:41 AM
  4. search engine in excel
    By ejlersen in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 04-14-2013, 06:23 AM
  5. Search Engine in Excel
    By lorenzoscott78 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2012, 11:21 PM
  6. Developing Search Engine to search several Excel sheets
    By cruiser102 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2009, 09:30 AM
  7. search engine in excel
    By Mrrobinson in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 06-29-2008, 10:23 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