Find Jobs
Hire Freelancers

Excel: vba importing bulk txt files (in one folder) into one workbook: each txt in one cell

€8-30 EUR

Imekamilika
Imechapishwa about 5 years ago

€8-30 EUR

Kulipwa wakati wa kufikishwa
I have about 2000 txt-files in one folder ("data-folder"). I need a vba code that I can bulk import the content of each of the txt-files into one cell in one workbook. for example: Content of [login to view URL] should be in cell A1 Content of [login to view URL] should be in cell A2 Content of [login to view URL] should be in Cell A3 ... I´m an absolute beginner regarding xls and vba. I found the following ressources that solve parts of my problem, but i don´t find the ready code for solving this task: 1) in this solution, every line in the txt is imported into one line in the workbook: [login to view URL] and here (shows an error message): excel vba - import folder of .txt (tab delimted) files into next available row I think there is only a small piece missing for my task. So if there is someone who can adjust the code for me, this would be great. Thank you in advance. Best Regards
Kitambulisho cha mradi: 18896184

Kuhusu mradi

19 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Hello there, I am an Excel expert with VBA skill. I can help you to review and check your VBA code. Please share me detail. Problem will be solved in 10 mins. Thanks
€10 EUR ndani ya siku 1
5.0 (34 hakiki)
4.2
4.2
19 wafanyakazi huru wana zabuni kwa wastani €31 EUR kwa kazi hii
Picha ya Mtumiaji
Hi, Had a look at the requirement. Kindly confirm and I shall deliver the code meeting your requirement within a day. Also, provide the folder with some sample text files for testing. Cheers, Arul
€30 EUR ndani ya siku 1
5.0 (259 hakiki)
7.4
7.4
Picha ya Mtumiaji
Hello Sir I can do import 2000 text file and paste it into one cell in workbook excel Sir please ping me now and im able to make macro right now Thank you Galih
€34 EUR ndani ya siku 0
4.9 (346 hakiki)
7.1
7.1
Picha ya Mtumiaji
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an application in Excel to enter about 2,000 txt files in adjacent cells. I will write the code from scratch. This is much easier for me. I can have it ready in a couple of hours. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 280 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you 30€ and can deliver within a couple of hours (a single milestone to release once you're satisfied with the final result). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
€30 EUR ndani ya siku 0
4.9 (201 hakiki)
7.1
7.1
Picha ya Mtumiaji
what if i make an application for u? just select files and it will get data in sheet? what if i make an application for u? just select files and it will get data in sheet?
€23 EUR ndani ya siku 1
4.9 (498 hakiki)
7.2
7.2
Picha ya Mtumiaji
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. Please share the file that you are currently using and I would fix it for you so that it can download contents of text files in appropriate rows. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Weekend! Srinivasan Krishnamoorthi
€15 EUR ndani ya siku 0
5.0 (171 hakiki)
6.7
6.7
Picha ya Mtumiaji
Hello client I can write the code for you. I understand the scope of work completely. Kindly contact me. Roy ........................................
€30 EUR ndani ya siku 1
4.9 (299 hakiki)
6.7
6.7
Picha ya Mtumiaji
Hi Sir I am available to start working now I have checked the code and you requirement. I will develop a macro to import csv from folder to each separate cell. Regards
€24 EUR ndani ya siku 1
4.9 (393 hakiki)
6.7
6.7
Picha ya Mtumiaji
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.
€29 EUR ndani ya siku 1
4.9 (117 hakiki)
6.2
6.2
Picha ya Mtumiaji
1. I am an expert in Excel,VBA, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
€100 EUR ndani ya siku 3
4.8 (65 hakiki)
5.6
5.6
Picha ya Mtumiaji
Hi, I am an excel VBA expert and can do this job for you within a day. Please provide me with the text file so that i can have a look. We will make the code in a way such that you can add more data to the text file and even the excel file will be updated accordingly. Thanks Sajid Khan
€22 EUR ndani ya siku 0
4.8 (39 hakiki)
5.2
5.2
Picha ya Mtumiaji
Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project done as you mentioned in the description. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Sapna Dalsaniya
€29 EUR ndani ya siku 1
5.0 (24 hakiki)
4.5
4.5
Picha ya Mtumiaji
Excel & VBA expert with over 8 years of experience. Can help to fix the issue as needed on the expected lines. Thanks
€34 EUR ndani ya siku 1
5.0 (12 hakiki)
3.8
3.8
Picha ya Mtumiaji
I can help you. I have rich experience in excel and VB, and I do my best to save your time and pocket. contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{Java, C#, VBA, PHP, HTML} • Web designing......................................{Wordpress} • 2D Graphic ...........................................{Photoshop, Macromedia Flash, ...} • 3D Graphic ...........................................{3dsMax, Blender, ...} • Engineering...........................................{AutoCad, Watergem, SewerCad, Flow3D, Elvis, ArcGIS, ...} • Researching .........................................{Green Energy, Solar cells, WaterManagement, ....} Services: ? Accuracy ? Customer satisfaction is my first "Priority" ? Time Commitment ? Availability Thanks, Shahin
€20 EUR ndani ya siku 1
5.0 (10 hakiki)
3.3
3.3
Picha ya Mtumiaji
Hi Good Day! I can help you with this project. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
€30 EUR ndani ya siku 3
5.0 (16 hakiki)
3.5
3.5
Picha ya Mtumiaji
Hello, i can help you with this project, the link attached will help a lot with the solution, so please send me a message and I will start working on it inmediately.
€14 EUR ndani ya siku 1
5.0 (9 hakiki)
2.8
2.8

Kuhusu mteja

Bedera ya GERMANY
Saarbrücken, Germany
5.0
3
Njia ya malipo imethibitishwa
Mwanachama tangu Mac 26, 2017

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.