Page 1 of 1

loop thru folder

Posted: Tue Sep 22, 2020 6:15 pm
by 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,

Re: loop thru folder

Posted: Tue Sep 22, 2020 6:25 pm
by sna
Here's the attached

Re: loop thru folder

Posted: Tue Sep 22, 2020 9:40 pm
by sna
Attached

Re: loop thru folder

Posted: Tue Sep 22, 2020 10:17 pm
by snasui
:D The attach file must less than 500 kb.

Re: loop thru folder

Posted: Tue Sep 22, 2020 10:41 pm
by sna
Here's the attached

Re: loop thru folder

Posted: Wed Sep 23, 2020 7:38 am
by snasui
:D 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

Re: loop thru folder

Posted: Wed Sep 23, 2020 9:47 pm
by sna
Thanks

Re: loop thru folder

Posted: Thu Sep 24, 2020 6:55 am
by sna
Thank will try it