Suoritettu

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

Taidot: tietojenkäsittely, Excel, tietojärjestelmäarkkitehtuuri, Visual Basic, Visual Basic for Apps

Näytä lisää: 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

Tietoa työnantajasta:
( 3 arvostelua ) Saarbrücken, Germany

Projektin tunnus: #18896184

Myönnetty käyttäjälle:

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 1 päivässä
(34 Arvostelua)
4.2

19 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 ( Lisää

€50 EUR 0 päivässä
(681 arvostelua)
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 1 päivässä
(259 arvostelua)
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 Lisää

€30 EUR 0 päivässä
(201 arvostelua)
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 1 päivässä
(498 arvostelua)
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 Lisää

€15 EUR 0 päivässä
(171 arvostelua)
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 0 päivässä
(346 arvostelua)
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 1 päivässä
(299 arvostelua)
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 1 päivässä
(393 arvostelua)
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 1 päivässä
(117 arvostelua)
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] Lisää

€30 EUR 1 päivässä
(83 arvostelua)
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 Lisää

€100 EUR 3 päivässä
(65 arvostelua)
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 Lisää

€22 EUR 0 päivässä
(39 arvostelua)
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 Lisää

€29 EUR 1 päivässä
(24 arvostelua)
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 1 päivässä
(12 arvostelua)
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 ........ Lisää

€20 EUR 1 päivässä
(10 arvostelua)
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 Lisää

€30 EUR 3 päivässä
(16 arvostelua)
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 1 päivässä
(9 arvostelua)
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 Lisää

€26 EUR 3 päivässä
(5 arvostelua)
2.3