Sedang Disiapkan

program to convert csv files needed

I need you to create a macro that would process csv files.

Please read following carefully and ask question in pmb if you are unclear about something.

I will have a report in excel format which will have several [url removed, login to view] of those columns I will have to convert. It's not always the same column(sometimes it could be D sometimes it could be C and so forth).I will also have a 'relationship file' which is excel sheet with [url removed, login to view] will be two column spreadsheet .First column is value that needs to be found in original spreadsheet and second column is what it needs to be replaced for.

I need you to write a macro that would add another column to that original report after last one.I need to be able to load 'relationship' file in to the [url removed, login to view] I need to be able to 'tell' macro which column I want to work with (for example clumn D) and once macro completed sequence I want to be able to save the result in csv file.

I need to be able to set as many relationships in the relationship reference file as excel will [url removed, login to view] I need to be able to load different relationship file in to the macro if I had to.

Example:

I downloaded csv with 1000 lines. I need to add one more column after the last one in that report. I load this csv report file in your macro,load reference file,tell macro which column to look in , execute macro and save result in new csv [url removed, login to view] result have the same report with additional [url removed, login to view] reference spreadsheet should have first column as what to look for and second column is what to replace it for.

Reference spreadsheet could be 5 lines or 5000

I hope I explained it clearly.

If you still have a questions I will be happy to answer any questions.

Kemahiran: Excel, Visual Basic

Lihat lebih lanjut: cdspace, csv convert database vba, convert csv macro, macro convert csv excel, csv spreadsheet, save excel, forth, CSV, any program, spreadsheet csv, report needed, excel macro add, write macro, load excel, excel file convert, save excel read, excel macro csv, csv column format, file load save, excel report macro, excel macro program, csv convert, visual read files, save report, read lines

Tentang Majikan:
( 1 ulasan ) Raymond, United States

ID Projek: #301885