-
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
-
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.
-
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
-
Forum Rules