Hello people
I got following folderstructure for my order numbers see picture below:
LxlnoJW.png
I generate an order number from my excel file, then I need to locate the folder with the ordernr
Could someone help me to make a code that looking for example the order 32342 msg the folder + path
Thank you in advance
Please click the * below if this helps
Please Login or Register to view this content.
Please click the * below if this helps
What does your script ?
I think you have misunderstood the things I want.
All the order numbers are not in the excel file I just call a certain value from a string
then I need to locate the folder through explorer and do some stuff with the folder named (the string)
as the picture I view over, I want to find a certain folder(32342 example) in explorer then open the folder
the problem is I don't know the whole path
well, if you read my code you see what it does - it finds the location of the folder.
Replace the specified variable "whut" with an inputbox or refer it to a cell or something.
You'll have to add in code to open the folder.
Adjusted code, assuming your order number or whatever is in A1:
Please Login or Register to view this content.
Last edited by JasperD; 06-04-2015 at 10:23 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks