make a list of file name from a folder and sort accordingly

**dragon_m0nsta** · 08-06-2012, 12:30 AM

hi there,

i would like to have some help here.

i would like to produce a list of file name from a folder.

and i have done it partially which i get from my friend. this is the VBA code.

Please Login or Register  to view this content.

my problem is, i would like the data made in a particular subject for each column.

let me give you an example.

the file name is DATE_HN#12_PO#123456-01_PN#7890123_SN#4

i would like to divide the data into three column.
column A14-... DATE,column B14-... PO# (just the number only) and column C14-... PN# (just the number only)

thank you in advance

**MaczaQ** · 08-06-2012, 03:13 AM

consider to use "Mid" function
pseudo code: Mid(string,start position, length)
i.e.

Please Login or Register  to view this content.

**Cutter** · 08-06-2012, 10:19 AM

@ dragon_m0nsta

Welcome to the forum.

Please notice that code tags have been added to your post (instead of the colour highlight). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

**dragon_m0nsta** · 08-07-2012, 01:39 AM

thank you.

---------- Post added at 01:39 PM ---------- Previous post was at 01:38 PM ----------

sorry for that. i will use the code tags after this.

thank you for reminding