Închis

VBA Excel Code. Generate the CSV file from Excel spreadsheet according to template

Goal:

Generate the CSV file from Excel spreadsheet according to template (order and default values of the columns). Formulas are converted into the values.

Milestones:

1. Generate CSV (with ‘;’ as separator) from current Excel data-sheet (formulas are converted into the values)

- Verify if the rows have the same value in a certain field (aggregation key)

- Changing the order of the column according to the template

- Allow have only some of the columns in the data sheet compared to the template. The column still will be generated in the CSV, but empty.

- Allow to have default values in the template for those columns which are not in the Data sheet.

2. Additional requirements to CSV file:

- Generate with the header/footer

- Generate CSV with a specific name

3. Generate only for the selected entries

4. Generate alternative CSV (other structure) (optional)

5. Log generated entries. Verify if there are duplicates (optional)

Milestones 1-3 are the scope of the project. The project ends with these 3 milestones unless we agree and extend it by 4th and/or 5th milestones.

Detailed exaplanantions in the attached .docx

Aptitudini: Excel, Visual Basic pentru aplicaţii

Vezi mai multe: macro to convert multiple excel files to csv, excel vba export sheet to new workbook, how to save a worksheet in excel to a separate file vba, vba export table to csv, excel macro import csv to worksheet, excel vba save as csv with prompt, vba save as csv comma delimited, excel export multiple sheets to csv, php code download csv file, vba code generate report excel, vba code create pdf file access 2007 report, generate csv file rss feed, can articulate generate csv file, vba sql auf csv file, html code generate pdf file perl, php code generate design file, javascript generate csv file, aspnet code importing csv file access, generate csv file php, full code show csv file data grid

Despre angajator:
( 55 recenzii ) Frankfurt am Main, Germany

ID Proiect: #18947817

17 freelanceri licitează în medie 90€ pentru acest proiect

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 2 zile
(667 recenzii)
8.4
bouslimi1979

Interested **********************************************************************************************************************************************************************************************

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 5 zile
(265 recenzii)
7.5
TonmoyRoy111

Dear client I can write the macro code for you. I have gone through the instructions and the excel file also. I ensure the job will be done with perfection. Please contact me. Roy

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(296 recenzii)
6.7
usmanhassan123

I have read your project description and I am agree with you with partial milestones method. Msc computer science. MBA accounts and finance. Mphill in statistics. having seven years of experience in Excel vba and Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(59 recenzii)
6.0
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(49 recenzii)
5.3
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(81 recenzii)
5.5
sorinacho88

Hello, I have taken a look at the instructions and I can build the macro for you. Please see below a short list of my skills: - Attention to details - Focus on quality - Advanced Excel/VBA - Patience - Good En Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 4 zile
(46 recenzii)
5.0
urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(24 recenzii)
4.7
hemsingh1

Excel & VBA expert with over 5 years of experience. Can help to develop a solution as specified based on the requirements specified. Thanks

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 2 zile
(9 recenzii)
3.2
ielucerotrad1

I can do the job! Pretty straight forward task, just might need some clarification to make sure macro does what you need. I'm an engineer with advanced working knowledge and experience in Excel, VBA and VBA interacti Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(5 recenzii)
2.4
sachavukic

Hello, I'm programming Excel Macro for more than 25 years. The specifications you wrote are clear, and I didn't see missing information at first sight. Sacha.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 2 zile
(5 recenzii)
2.4
stanleyw12

Hi Sir/Mdm Thanks for reviewing my application. I am well versed in VBA having used it in various financial institutions. As I am a new freelancer, I am willing to do this job at a cheap cost or even for free. Pleas Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(5 recenzii)
1.7
Wantse

Hello, I have done a similar project before. With the generated csv, would you like it to be saved to a specific directory or a prompt asking where to save it? All milestones described are possible, I just have a few Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(4 recenzii)
1.6
Rocabaves

I am a tireless seeker of knowledge, occasional purveyor of wisdom and also coincidentally, a graphic designer. Sometimes i create posters, e-cards, logo and t-shirt designs. I am a person who has a high passion in des Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(1 părere)
1.0
umalakindia

Hi I am interested in taking this project. I have development experience in VB.net and in Excel macros. So i can work on this project. Please let me know further details to proceed.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 7 zile
(0 recenzii)
0.0
HiginioGC

Experience on the Visual Basic Excel Macros, created of files. Created of formula on the Macro of Excel modifated of data

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(0 recenzii)
0.0
vw2094346vw

I bid 7 days. Because I could not spend all time for this. I could only work 2-4 hours per day. I am very excited with this. Thank you very much.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 7 zile
(0 recenzii)
0.0