PDA

View Full Version : [SOLVED] Select a found file and open in explorer



elmnas
06-05-2015, 12:17 AM
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?


http://www.excelforum.com/clientscript/select_all_icon.jpg http://static.beckelman.net/v1/img/page_white_copy.png
searchwin = "34228"
pathwin = "X:\XXX\XXX\XXX\"
Call Shell("explorer ""search-ms://query=" & searchwin & "&crumb=location:" & pathwin & """", vbNormalFocus)


Thank you in advance

snb
06-05-2015, 12:38 AM
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.

elmnas
06-05-2015, 12:46 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.