Hi,
I would like a macro to open any and all .csv files into excel (new window) found withing a specific directory one at a time (may need user prompt to keep organized). Once the code has opened the first .csv file and has focus on it, I have a macro in place to copy it's data and paste into an existing table's next empty row in a specific worksheet of an already opened workbook. After I have ran the macro said above, I need the code to close this newly created and temporary .csv file and open the next it finds in the specified path. If the code does not find any other .csv files then stop or tell me that it has stopped checking because there were no more to be found.
Is this possible?
If it is, how would this code be written ?
I would like a macro to open any and all .csv files into excel (new window) found withing a specific directory one at a time (may need user prompt to keep organized). Once the code has opened the first .csv file and has focus on it, I have a macro in place to copy it's data and paste into an existing table's next empty row in a specific worksheet of an already opened workbook. After I have ran the macro said above, I need the code to close this newly created and temporary .csv file and open the next it finds in the specified path. If the code does not find any other .csv files then stop or tell me that it has stopped checking because there were no more to be found.
Is this possible?
If it is, how would this code be written ?
