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 [login to view URL] 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 [login to view URL] 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 [login to view URL] 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 [login to view URL] 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 [login to view URL] result have the same report with additional [login to view URL] 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 lagi: what to program, convert your files, cdspace, csv convert database vba, convert csv macro, macro convert csv excel, what is macro in excel, csv spreadsheet, save to excel, forth, csv, convert, convert file, any program, excel visual basic file load, 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

Tentang Majikan:
( 1 ulasan ) Raymond, United States

ID Projek: #301885