I understand opening and getting info I need and I think it might be easier to calculate my forecast formula on each fiile I open then copy the exact cells I need which would be 7 specific cells. I will not be needing to save the files just close them out even though I am calculating a formula from data which I then will pull off values into my worksheet. But now How do do this on a loop?
I am still confused on how to go about opening 74,00 csv files in a loop. An example of the files names are as follows:
What does change is the date & military time eveything else is repeated in 15x blocks of:
Not sure what is an easy method to opening up files in 15x blocks or all PinkA then Pink B, etc thatt way the system does not crash trying to open so many files (74,000). Any help with the code would be helpful. I have code to insert my FORECAST function into the csv file then pulling data from those cells and copy to a workbook but now How do I tackle the mountain of opening csv files 74,000 times besides manually 74,000 times.