Chunk
10-16-2018, 10:23 AM
Looking for help.
I am fairly new to VBA and am trying to accomplish the following:
I have multiple csv files (up to 80) in a central location, that I need to open and possibly edit (by deleting column "A" if it has "FileName" in "A1").
I then need to rename the file to be able to use it in another application.
An example of the file name that I receive is:
PPS_PROJECT1_F18_January_XXX_10JAN2018.csv
I need it to be renamed (using the Main workbook for the conversion):
POA01_Q1_10JAN18.csv
I am using Main workbook to initiate the conversion and hold the lookup list for the projects.
Attached are 4 example files (3 that need the first column deleted and one that does not) That I receive and the Main workbook.
Any help/tie yo can give is greatly appreciated. Please let me know if you require more information.
Sincerely,
Chunk
I am fairly new to VBA and am trying to accomplish the following:
I have multiple csv files (up to 80) in a central location, that I need to open and possibly edit (by deleting column "A" if it has "FileName" in "A1").
I then need to rename the file to be able to use it in another application.
An example of the file name that I receive is:
PPS_PROJECT1_F18_January_XXX_10JAN2018.csv
I need it to be renamed (using the Main workbook for the conversion):
POA01_Q1_10JAN18.csv
I am using Main workbook to initiate the conversion and hold the lookup list for the projects.
Attached are 4 example files (3 that need the first column deleted and one that does not) That I receive and the Main workbook.
Any help/tie yo can give is greatly appreciated. Please let me know if you require more information.
Sincerely,
Chunk