A device create a datafile every 5 minutes. These datafiles are put into a directory. In Excel there a is workbook that creates a new sheet for each datafile. Now I have to fill in a variable in a vba macro that stands for the number of files in this directory. This number of files will be processed in the workbook.
But in the meantime there are new datafiles in this directory and these are not proccessed.
Now I like the vba macro to look into this directory and everytime when there is a new datafile it should be processed with the vba macro in this workbook
Is there someone who knows how i can do this?
But in the meantime there are new datafiles in this directory and these are not proccessed.
Now I like the vba macro to look into this directory and everytime when there is a new datafile it should be processed with the vba macro in this workbook
Is there someone who knows how i can do this?
Last edited:
