Check directory for files.

  • Hello,

    I have made an macro that loops 3 times a day.
    What it does is very simple.
    It combines 3 *.csv files into one, save it with time and date and remove the original file.
    This is working perfect, but....

    If there are no file in the directory the macro gets corrupt and doesn't know what to do anymore.

    So i think it must check if there is a file in the specified directory and then run the original macro.

    what do you think??

    thanx

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!