Hi Paul, Please check the attached file, as asked.
Thanks, Devendra On Mon, Feb 29, 2016 at 7:29 PM, Paul Schreiner <schreiner_p...@att.net> wrote: > Sorry for the delay. > I spend 10-12 hours a day throughout the week on a computer. > When a beautiful weekend comes along, I tend to spend my time doing other > things and never even APPROACHED my computer! > > Please see my earlier response. > > *Paul* > ----------------------------------------- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----------------------------------------- > > > On Monday, February 29, 2016 8:51 AM, Paul Schreiner < > schreiner_p...@att.net> wrote: > > > > IF I understand correctly, your task should be easily accomplished. > I've done something similar in the past. > But my criteria was based on total file size. > > Do ALL of your filenames consist of 7 fields separated by "-"? > > If you were to use split() on your filenames, using "-" as a delimiter > would fields 0-3 make up the "article" and array(5) represent the > "sequence"? > > Given a list of files in your folder, we could easily create a list like > your Sheet1 example. > > If you could open the attached file and change the folder name in cell B1 > of the FileList sheet, > then run the file_list macro (or double-click cell A1). > Then send me the file. > I'd be glad to write a simple macro to parse out the file names. > > > > *Paul* > ----------------------------------------- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----------------------------------------- > > > On Sunday, February 28, 2016 8:19 AM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > > > > Hi Experts, > > Sorry for posting such a big query on forum but this issue is time taking > & i want to do it in smart way but not able to do. So please check the > below mentioned scenario & assist. > > Scenario- > I have 2000 (.jpg ) images in a folder, with a similar names like > mentioned ( only difference of their sequence no, highlighted"-M-2-2x.jpg") > & due to some tech limitation system doesn't allow to upload more than 200 > Images at one time ( It might be less according the image sequence for eg > the last sequecne is M-8 then no of the images might be less than 200 ) > Currently am manually checking the sequence of the images & moving them in > folders ( Prepare batches to upload ) after that using a batch file, i get > the file names of images, including their extension name.after that I > separate the name of the article no from image name for eg. image name is > "GAH-INZ-PRT-01AS-M-2-2x.jpg" then article no would be "GAH-INZ-PRT-01AS" > and after that using some excel functions i prepare a upload sheet like i > have attached. > > *Required solution : -* > > Step 1 -I want to prepare batches of images ( code can decide & check the > last no of sequence for eg. i have 35 article & each article no have 6 > images, then it would only prepare first batch of 35 articles ) > > > Step-2 Get the filenames in created folders ( for 35 articles ), there > would be a pop-up to select the folders manually. after that separate the > article no from image naming & prepare the upload sheet ( like attached ) & > save the prepared excel sheet in same folder, which i have selected. > > @Mandeep & Paul, I have much expectations from both of you, Please assist. > > > Thanks, > Devendra > > > -- > > With Regard !!! > Devendra Rahi > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- With Regard !!! Devendra Rahi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Uploadsheet.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
