jeremyp
11-06-2012, 03:21 AM
Dear VBA Express community,
I will reward whoever manages to help me out with €50 transferred in whatever means of payment you prefer (paypal, wire transfer etc).
I have a list of CSV files in a folder, and an excel file listing all of these files.
What I am trying to do is to create a new column to the right of the search paths for the CSV files that gets me $A$1 from all of these cells.
I have attached example to make it more clear. Please note that all the CSV contain only 1 data point (i.e all cells other than $A$1 are empty). Also note that the list I have provided is only a sample - It would be great if the VBA macro was as "general" as possible, so something in the lines of:
1. Select all file folder references in columna A
2. Select folder in which the CSV fiels to be searched are placed
3. Let the magic happen :)
Kind regards,
Jeremy
I will reward whoever manages to help me out with €50 transferred in whatever means of payment you prefer (paypal, wire transfer etc).
I have a list of CSV files in a folder, and an excel file listing all of these files.
What I am trying to do is to create a new column to the right of the search paths for the CSV files that gets me $A$1 from all of these cells.
I have attached example to make it more clear. Please note that all the CSV contain only 1 data point (i.e all cells other than $A$1 are empty). Also note that the list I have provided is only a sample - It would be great if the VBA macro was as "general" as possible, so something in the lines of:
1. Select all file folder references in columna A
2. Select folder in which the CSV fiels to be searched are placed
3. Let the magic happen :)
Kind regards,
Jeremy