Consulting

Results 1 to 3 of 3

Thread: Select a found file and open in explorer

  1. #1
    VBAX Contributor
    Joined
    Jun 2014
    Posts
    114
    Location

    Select a found file and open in explorer

    Hello all Members,




    I have made following code below

    The script search for a file on a certain path,

    How do I make the script select the folder and open it when found?



    searchwin = "34228"
    pathwin = "X:\XXX\XXX\XXX\"
    Call Shell("explorer ""search-ms://query=" & searchwin & "&crumb=location:" & pathwin & """", vbNormalFocus)



    Thank you in advance

  2. #2
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,635
    If you do not provide any information what you are trying to achieve no sensible advice can be given.
    You might start to acquire the basics in VBA by studying a book.

    After 71 posts in this forum you should be familiar with the use of code tags.
    Last edited by snb; 06-05-2015 at 01:15 AM.

  3. #3
    VBAX Contributor
    Joined
    Jun 2014
    Posts
    114
    Location
    Hi again,

    Well I trying to open a folder the script find then take the .zip file copy to a temp folder then unzip.
    open a xml file then take a certain value from a certain node, then paste in the excel sheet.

Tags for this Thread

Posting Permissions

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