Recent Activities
-
anmac1789
Replied to the thread excluding folder paths with spaces.Posti see, okay i will make a new thread -
fi1808
Posted the thread How to update a cell when new data is entered.ThreadHello, I needed help with something im working on.
I have a set data of data that counted average data of several years.
There is a column of average that i hid to help with the calculation.
Below my data which is a bar chart is a total for annual average
… -
gijsmo
Replied to the thread excluding folder paths with spaces.PostThe code I suggested in my previous post will fix the issue of the "\" on the end of the parent folder - if you don't add it to the parent folder in cell A1, the code will simply add it for you. This seems to work OK for all the test cases I've created… -
anmac1789
Replied to the thread excluding folder paths with spaces.Postin addition to post #6 - it seems like the problem now is for longer parent folder paths...the files do not even show up..the path length is "C:\Users\[username]\Downloads\duracell 4GB" -
anmac1789
Replied to the thread excluding folder paths with spaces.Postso basically, your saying that I just need to add a "\" to the parent path ?? Also, what if i want to get all subfolders within a parent directory but I want to exclude a deeper nested subfolder ? how can I adjust the code? -
gijsmo
Replied to the thread excluding folder paths with spaces.PostThe problem I think is not including the final backslash in the parent path, this should be fixed by adding this line in the ListMyFiles sub:
(Code, 2 lines)
best place is probably here:
(Code, 4 lines) -
pranavk
Replied to the thread IF Else Conditions on cell which has formula.PostSorry for late response, i created a temp column with values then used the find formula there to make it work. As the original column had formula instead of values. When its values in column then find works like charm.
Thank you for your inputs My Roy and… -
pranavk
Liked Carim’s post in the thread IF Else Conditions on cell which has formula.Like (Post)Feel free to share your comments ... -
pranavk
Liked Carim’s post in the thread IF Else Conditions on cell which has formula.Like (Post)Hello,
Have you tested
(Code, 7 lines)
Hope this will help -
pranavk
Liked royUK’s post in the thread IF Else Conditions on cell which has formula.Like (Post)If t is not returning "Nine" then the the code will not find anything. -
anmac1789
Replied to the thread excluding folder paths with spaces.PostI think the problem is occurring with "asf() = Split(Replace(excludedSubfolders, ", ", ","), ",")" -
poojums
Replied to the thread If false do nothing.PostI have created a similar thread, but left that one open to any suggestion as the solution.
In this thread, I would be keen to know if false statement can do nothing - for any future reference. -
poojums
Replied to the thread Grow the table every month/quarter.Postattached a sample worksheet -
Carim
Replied to the thread If false do nothing.PostIf I am not mistaken ...
You have just created a new thread with exactly the same question ...
By the way ... feel free to attach a sample worbook ... -
poojums
Posted the thread If false do nothing.ThreadI have a table with data for last quarter
Months Value
Oct-20 10
Nov-20 20
Dec-20 18
Another table with historic data that I want to grow:
Months Value
Jan-20 10
Feb-20 18
:
:
Oct-20 ---
Nov-20 ---
Dec-20 … -
Carim
Replied to the thread Grow the table every month/quarter.PostHello and Welcome to the Forum
To make everything easier for everybody ... just attach a sample workbook -
Carim
Liked dilshod_k’s post in the thread Troubles when Creating workbooks from worksheets..Like (Post)(Quote from Carim)
Now it works perfectly well. Thanks a lot!
Appreciate your help.
Dilshod -
Carim
Replied to the thread Troubles when Creating workbooks from worksheets..PostYou are very welcome
Thanks a lot both for your Thanks ... AND for the Like