Find Jobs
Hire Freelancers

Changing excising Excel VBA program with a new CSV input format

$10-30 USD

Zavřený
Zveřejněno skoro před 3 roky

$10-30 USD

Zaplaceno při doručení
I have a Excel VBA program with some function and would now like to change the input CSV file format to a slightly different csv format. New Functions Program MS-CSP V1.7 Black text existing function that should remain Green text Disable functions Red Text new functions or changes The main thing here is that I´m changing the input file with another column format and I want the Program MS CSP to adapt for the new format. The output from this new file should be the same as the input file in meaning the column, It means that the program should not delete any columns or move them for the output file. When using Import Button: The new file has 108 colomns (A-DD) (And the old one had 107 columns A-DC) The file name begins now with XSP_DailyBillFeed When Using "Report Button" Button Change following from where it should take the information in the new file. Change column from CI to CQ Change column from CK to CS Change column from CL to CO When Using "Calculate" Button change following functions The Program should not change and delete any columns, is should be the same format as it first is imported as it should be as output format. If Column (CI) "Reseller Reference" (Exact spelling) exist, delete the whole column. If Column (CJ) "Customer Reference" exist, delete the whole column. If Column (CK) "Category" exist, delete the whole column. If Column (CL) "Issue Date" exist, delete the whole column. If Column (CN) "Validation Date" exist, delete the whole column. If Column (CO) "Arrow Contact ERP ID" exist, delete the whole column. If Column (CP) "Reseller Contact ERP ID" exist, delete the whole column. If Column (CQ) "Customer Contact ERP ID" exist, delete the whole column. If Column (CR) – “Retail Unit Price” exist, delete the whole column. If Column (CS)- “Retail Total Price” exist, delete the whole column. If Column (CT)- “Rate” exist, delete the whole column. If Column (CU)- “Customer Unit Price” exist, delete the whole column. If Column (CV) – “Customer Total Price” exist, delete the whole column. If Column (CW) – “ERP Invoice ID” exist, delete the whole column. And move Column "Billing ID" after column (CG) "Reseller Company Tags" And move Column “Customer Billing ID” after column (CH) “Billing ID” And move Column “Exchange Rate (Service Provider Currency)” after column (CI) “Customer Billing ID” And move Column “Vendor Unit Price (Service Provider Currency)” after column (CJ) “Exchange Rate (Service Provider Currency)” And move Column “Total Vendor Price (Service Provider Currency)” after column (CK) “Vendor Unit Price (Service Provider Currency)” And move Column “Pro/Rated Wholesale Unit Discounted Price (Service Provider Currency)” after column (CL) “Total Vendor Price (Service Provider Currency)” And move Column “Total Wholesale Price (Service Provider Currency)” after column (CM) “Pro/Rated Wholesale Unit Discounted Price (Service Provider Currency)”
IČ projektu: 30119639

O projektu

19 nabídky
Vzdálený projekt
Aktivní před 3 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
19 freelanceři nabízejí v průměru $38 USD za tuto práci
Avatar uživatele
Hi, I am well versed with Excel VBA and can help on this. Please share the VBA program so that I can look at the existing code and also can correlate the instructions in Word document better. Looking forward to your response. Thanks
$35 USD v 2 dnech
4,9 (224 recenze)
6,8
6,8
Avatar uživatele
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours
$20 USD v 1 dni
4,9 (147 recenze)
6,2
6,2
Avatar uživatele
Hello, I can help you to update the code for the desired output, please send me a message with more details and I can start working on it inmediately
$20 USD v 1 dni
5,0 (40 recenze)
4,4
4,4
Avatar uživatele
Hi I have 10+ years of experience in VBA programming and database management. I checked all the requirement and can make changes in the tool as per new requirement or new input file. I worked several similar project in the past and ensure to deliver the project most efficiently. If interested, we can connect via chat and get started. Thanks Shivani
$20 USD v 1 dni
4,6 (22 recenze)
4,0
4,0
Avatar uživatele
Hello, **Delivers high quality product on time** **Implements Coding Standards** **Write comments for easy maintenance** I have gone through the requirements, Please share the existing macro and new csv file. So that I can implement the requirements and presents to you. I have 7 years of experience on VBA macros, C#, WinForms/WPF, Automation and Sql Server Thanks,
$30 USD v 2 dnech
4,9 (9 recenze)
3,3
3,3
Avatar uživatele
Is the vba job still pending? I can finish it for you. description are nice and neat still its better to see excel file before start the work. please come in chat. have a good day.
$25 USD v 1 dni
5,0 (3 recenze)
2,4
2,4
Avatar uživatele
Hello, I read your project description and understand all. I have 20 years in Database development, Training, Database administration, System Analysis, Data Analysis using Ms. Word, MS power point, Ms. Access, Ms. Excel VBA, VB6, Vb.net, C#, Oracle, MySQL, and MS SQL server I will make the perfect product what you want. I promise to complete your project within your time and budget beyond your expectations. I am willing to work at lower pay. Let me know when we can discuss and share all.
$30 USD v 7 dnech
5,0 (2 recenze)
1,5
1,5
Avatar uživatele
Hello, I am interested in this job. I am very confident that I can do this. I can Change excising Excel VBA program with a new CSV input format.
$20 USD v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I have read your Job description and I basically think its the right kind of work that I would like to put myself into. As with your description, I am very well acquainted with creating customized spreadsheet models (in MS Excel and Google Sheet) and I have good grasp over the powerful and advanced formula and features. I can make your workflow automated not only for this particular job but also for the similar ideas in future. Also, I will enhance the user interface by minimal user input (by adding macros). I will make your User-interface simple friendly enough where one can manually put several criteria and find the desired results. For your information, I have done several works similar to what you require. If you can share the contents, it will be much easier and specific. For your reference, I am sending you a job file that I worked with few weeks ago where you can see the interlinked complexities that I can deal with. I assure you that you are going to love my work if given a chance. Well if you find my description compelling then we can work together for better results. I am looking forward for more specific requirements about the job from your side Best Regards, Suman I hope to work with you
$20 USD v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Dear Sir/Madam, I am an engineer by profession, but I love Excel, especially the logic & programming aspect of the application like data analysis, creating formulas, macros & Visual Basic for Applications (VBA) codes. I started using Microsoft Excel in 1995 and did numerous projects with it; to improve some production processes, including administrative or clerical-related matters in the manufacturing companies I have worked. I already have ample time in my hand to do what I love because I am no longer working in a company. Hope to have a chance to be of service to you. Sincerely yours, Jun Ursal
$20 USD v 5 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z SWEDEN
Kista, Sweden
5,0
6
Ověřená platební metoda
Členem od led 29, 2018

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.