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.
Uploadsheet.xlsx
Description: MS-Excel 2007 spreadsheet
