En curso

VBA Code to merge data intelligently between CSV, XLS, TXT files

I have couple of files in XLS, CSV and TXT formats.

I want to merge data between XLS <-> CSV and XLS <-> TXT formats.

XLS file has First Name, Last Name, Title, Email ID, Country, Phone No, Industry, Sub-Industry

CSV file has First Name, Last Name, Address, City, State, Zip and Mobile Number

TXT file also has similar fields like CSV files.

There are multiple XLS, CSV and TXT files.

I want to get a code developed, that can go to Directory 1 and take one file at a time and take one record at a time, and go to Directory 2 and take one file at a time and look for same First Name, Last Name and also potentially country, state or city. When a record found, then output excel file to be produced by merging data of both files. If multiple records in Directory 2 are found then both records to be merged with two entries in output file, but next to each other.

Output excel file should be closed each time it reaches 25MB file size. And new output excel file should be opened for upcoming records. File name should be labelled in succession. eg. File_1, File_2 etc..

Once output files are prepared and stored in Directory 3. Code should go to one output file in directory at a time and get all records in a particular state stored in a single output file e.g. File_CountryName_StateName_1, File_CountryName_StateName_2 and these files should be stored in Directory 4. So directory 4 should have country_state based files.

VBA code should try to read the files without opening them to avoid memory and CPU issues.

Followed by this script, another script should be prepared. This script will go to a web page, perform search based on search form on page, get data. Then go to the file that was generated by the script prepared above and find out the correct record and generate another output file for all those found records by adding relevant fields to the final output file in Directory 5.

Please provide fixed price quote in INR.

Habilidades: Microsoft Access, Arquitectura de software, Desarrollo de software, VB.NET, Visual Basic

Ver más: source code merge data text file, free vbs sample script import txt files xls, java merge txt files example, java source code merge txt files, vbscript merge txt files, sample code grab data files, visual basic merge files code, code merge text files, visual basic code merge text files, php code send data csv, vba merge txt files, convert txt files csv files, vbs merge txt files, txt files merge vbnet, merge txt files vbs, merge txt files

ID de proyecto: #12780138

Adjudicado a:

iTinkerBell

Hello, I'm an expert of Microsoft Office If you don't mind, I can make a Python script (not VBA) to do the job. It can read, analyse, and merge data without really opening office files. I think I can help you. Thank Más

₹4000 INR en 2 días
(8 comentarios)
4.0

10 los freelancers están ofertando un promedio de ₹9690 para este trabajo.

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Más

₹14000 INR en 1 día
(30 comentarios)
5.4
mrbrave

Hi, I am expert in developing VBA macros for Excel and can complete this macro within couple of hours. I would like to discuss the project in detail with you.I feels there's some point missing here. Approx how m Más

₹7777 INR en 1 día
(86 comentarios)
5.8
cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using VBA scripts other Más

₹7400 INR en 1 día
(48 comentarios)
5.9
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Más

₹11111 INR en 3 días
(19 comentarios)
4.5
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana Más

₹9000 INR en 10 días
(11 comentarios)
3.8
gr8tech

I have experience in Excel, VBA for data analysis and processing. I have done a number of projects involving processing data from xls, CSV or delimited text files. I am also able to use scripts such Python and database Más

₹8888 INR en 1 día
(15 comentarios)
3.5
ksinghrajeev

Hi, I can do this. Here are some examples of my work. Project Report Automation - https://www.dropbox.com/s/tt0q9qhfq3s4izm/eBird%20FEP%20Plan%2012_Feb_15.xlsm?dl=0 Log Report Automation - https://www.drop Más

₹11111 INR en 5 días
(7 comentarios)
3.6
₹11111 INR en 10 días
(2 comentarios)
0.0
nurnga1218

Can you give me some files sir? So I can proof you how I will do what you require. For your consideration, I am an excel expert and a fast typist. You can see my portfolio to proof it. Thank you. Hope we'll discus Más

₹12500 INR en 2 días
(0 comentarios)
0.0