Recent Activities

  • cnucnucnu

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • anmac1789

    Replied to the thread excluding folder paths with spaces.
    Post
    i see, okay i will make a new thread
  • fi1808

    Thread
    Hello, 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.
    Post
    The 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.
    Post
    in 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.
    Post
    so 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?
  • antasari

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • gijsmo

    Replied to the thread excluding folder paths with spaces.
    Post
    The 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

    Post
    Sorry 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

    Like (Post)
    Feel free to share your comments ...
  • pranavk

    Like (Post)
    Hello,

    Have you tested
    (Code, 7 lines)


    Hope this will help
    :)
  • pranavk

    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.
    Post
    I think the problem is occurring with "asf() = Split(Replace(excludedSubfolders, ", ", ","), ",")"
  • poojums

    Replied to the thread If false do nothing.
    Post
    I 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.
    Post
    attached a sample worksheet
  • Carim

    Replied to the thread If false do nothing.
    Post
    If 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.
    Thread
    I 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.
    Post
    Hello and Welcome to the Forum :)

    To make everything easier for everybody ... just attach a sample workbook ;)
  • Carim

    Like (Post)
    (Quote from Carim)

    Now it works perfectly well. Thanks a lot!
    Appreciate your help.
    Dilshod
  • Carim

    Post
    You are very welcome ;)

    Thanks a lot both for your Thanks ... AND for the Like :thumbup: