Concluído

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

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

Habilidades: Processamento de dados, Excel, Arquitetura de software, Visual Basic, Visual Basic para Apps

Veja mais: merge multiple csv files into one excel workbook, import multiple csv files into one excel worksheet, merge csv files online, how to import multiple text files into excel on one worksheet vba, how to import multiple text files into one excel spreadsheet, import multiple xml files into excel vba, import multiple csv files into excel vba, import text files into excel, excel vba listing files folder, excel vba list web files, excel based vba search music files folder arrange, vba mac list files folder, excel vba format xml files, freelancer https www freelancer com projects data entry data processing build excel published books from html utm_campaign lates, freelancer https www freelancer com projects data entry data processing build excel published books from html utmcampaign lates, https www freelancer com mobile app deep link php url https 3a 2f 2fwww freelancer com 2fprojects 2fdata entry 2fsome excel work, https www freelancer com projects data entry some excel work 10628254 utm_campaign latest_project_contest, https://www.freelancer.com/projects/Excel/Fill-Spreadsheet-with-Data-14343803/, excel vba change shape color based on cell value, excel vba unzip all files in a folder

Acerca do Empregador:
( 3 comentários ) Saarbrücken, Germany

ID do Projeto: #18896184

Concedido a:

nvchien94

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 em 1 dia
(34 Comentários)
4.2

19 freelancers estão ofertando em média €31 para esse trabalho

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 ( Mais

€50 EUR in 0 dias
(681 Comentários)
8.4
deepbluetech

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 em 1 dia
(259 Comentários)
7.4
paris2785

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 Mais

€30 EUR in 0 dias
(201 Comentários)
7.1
saqibmunir55

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 em 1 dia
(498 Comentários)
7.2
ksriniravi

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 tha Mais

€15 EUR in 0 dias
(171 Comentários)
6.7
prameswara

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 in 0 dias
(346 Comentários)
7.1
TonmoyRoy111

Hello client I can write the code for you. I understand the scope of work completely. Kindly contact me. Roy ........................................

€30 EUR em 1 dia
(299 Comentários)
6.7
rohitagarberg

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 em 1 dia
(393 Comentários)
6.7
rinabuoy13

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 em 1 dia
(117 Comentários)
6.2
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] Mais

€30 EUR em 1 dia
(83 Comentários)
5.5
citijayamala

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 Mais

€100 EUR in 3 dias
(65 Comentários)
5.6
sajidkhan45

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 fi Mais

€22 EUR in 0 dias
(39 Comentários)
5.2
dalsaniyasonu123

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 Mais

€29 EUR em 1 dia
(24 Comentários)
4.5
hemsingh1

Excel & VBA expert with over 8 years of experience. Can help to fix the issue as needed on the expected lines. Thanks

€34 EUR em 1 dia
(12 Comentários)
3.8
shahinrahimi

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 ........ Mais

€20 EUR em 1 dia
(10 Comentários)
3.3
paulodayto08

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 a Mais

€30 EUR in 3 dias
(16 Comentários)
3.5
maguirrer

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 em 1 dia
(9 Comentários)
2.8
bashir786wmc

You pay me after checking the work HI Thanks for the opportunity I have over 10 years of experience as a data entry operator. I can provide you all kind of the Data Entry Services (Copy of data from sites & my Manual Mais

€26 EUR in 3 dias
(5 Comentários)
2.3