Hi Everyone,
I use a reporting platform that downloads a CSV file daily for every month. these files go into G:\alpha\ali\tradeshop\2015-05 than t here are a folders for each day for example 20150501, 20150504, etc for each day of that month. Each of these daily folders have a number of CSV files however I just want to extract a particular csv file (which has exactly the same name in each of the daily folders) for each day in each folder. However weekends are not included and therefore folders are not created on these days.
I need a macro that will a) extract these CSV files of each day for the whole month. b) the dates will be different in each month therefore the csv files will be folders with different dates for each month c) place the data into a single file.
Thank you kindly.
I use a reporting platform that downloads a CSV file daily for every month. these files go into G:\alpha\ali\tradeshop\2015-05 than t here are a folders for each day for example 20150501, 20150504, etc for each day of that month. Each of these daily folders have a number of CSV files however I just want to extract a particular csv file (which has exactly the same name in each of the daily folders) for each day in each folder. However weekends are not included and therefore folders are not created on these days.
I need a macro that will a) extract these CSV files of each day for the whole month. b) the dates will be different in each month therefore the csv files will be folders with different dates for each month c) place the data into a single file.
Thank you kindly.
