Fix VBA Script to extract a customized CSV with custom delimiter instead of comma.

€8-30 EUR

Completed

Posted

over 2 years ago

€8-30 EUR

Paid on delivery

The "LanciaExport()" export a CSV with comma as delimiter. The task consist in make a VBA script that export with a customized delimiter. It's not possible to use the SaveAs function because the default delimiter is comma. To make it easier, I supply a function example that extract the file with a concatenation instead to use SaveAs. The delimiter must be defined by a variable because sometimes we need to use a different delimiter due to description fields that container semi-colon or comma. I repeat: 1) you can't use replace comma with other because comma is also in some fields! Please use the fuction inside the .bas that I attach. 2) You can't use the SaveAs function with CSVUTF8 because it returns always comma as delimiter. The export must be filtered in rows and column: 1) Rows filtered by "STATO", we only need rows with "3. Pronto da caricare" value 2) Columns filtered by color, we only need column with header colored with RGB(0, 176, 80) - Green

Visual Basic

Excel

Project ID: 32890822

About the project

5 proposals

Remote project

Active 2 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@writingapp

€0 EUR in 1 day

4.9

(186 reviews)

6.4

5 freelancers are bidding on average €34 EUR for this job

@AccountantArman

"Sir, i can create this macro adn it will work with the click of a button. I am expert in it and i bet that no one is more expert then me here on this website I am Excel VBA and Coding Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. It is my Sixth month here and I have 115+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "

€55 EUR in 1 day

4.9

(146 reviews)

6.4

@ha99256066

Hi, i am Harshit .and i know to manage all type of data entry works. and i am well experienced in it. Thank you Yours Harshit

€19 EUR in 7 days

0.0

(0 reviews)

0.0

@evgeniyvc

Hello, dear! I have a deep experience in C, C++ and Java. I’m also expertized in Software Architecture and design patterns. I’m very interested in your projects. I am a problem solver and working with C, C++ for over 10 years. I’ll finish your project perfectly. Please contact me. Respectfully yours.

€15 EUR in 7 days