loop thru folder

[sna]

Hi Dear,

I got some issue with loop thru folder to copy excel files and place it in a sheet continuously.

I have many excel files download from a system and place it a folder saved name as daily like 01-09-2020...etc

Here is my template


Best Wishes,

[sna]

Here's the attached

[sna]

Attached

[snasui]

The attach file must less than 500 kb.

[sna]

Here's the attached

[snasui]

You can add procedure for loop all path in your computer with these step:

1. Add one sheet and named PathAll
2. Add procedure named LoopAllPath
3. Modify old procedure for receive variable from LoopAllPath

See picture below.

AllPath.png

LoopAllPath.png

[sna]

Thanks

[sna]

Thank will try it