Looking to create a Do while loop to apply the below formula on each workbooks all sheets a folder have in PC. Right now applying this 1 by 1 on each workbook separately. Any help regarding post would be appreciated. Thanks
HTML Code:
Looking to create a Do while loop to apply the below formula on each workbooks all sheets a folder have in PC. Right now applying this 1 by 1 on each workbook separately. Any help regarding post would be appreciated. Thanks
HTML Code:
Hi and welcome to ExcelForum.
Change "C:\trabajo\folder2\" for the folder where the files are.
Please Login or Register to view this content.
Visit : Excel & Macro
https://www.youtube.com/@CursosDeExcelyMacros
Why the assignment to the function 'Array' is inside the loop (?), after all it is a "constant value" ...
Please Login or Register to view this content.
Why the assignment to the function 'Array' is inside the loop (?), after all it is a "constant value"
I didn't think about that, that's how it came in the original code.
But you're right, it should be out of cycles, it should go for example:
thanks for commentPlease Login or Register to view this content.
Apologies for replying late. I'have tried this code where it asking to add the folder link i want to select the folder via the code.
I have modified the code little as i want the code to work. But it is still not performing any action.
HTML Code:
Last edited by shabby01; 08-10-2020 at 06:36 AM.
I got by adding xFileName = Dir(xFdItem & "*.xlsx") thanks for your support.
I'm glad to help you. Thanks for the feedback.
shabby01, the variable 'Arr' is unnecessary in the loop as its value does not change, move it to the beginning of the code, that's where it belongs, e.g.:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks