VBA Excel Macro to Import Many Text files from Single Folder into Excel Sheet in each single cell in bulk

$10-30 USD

Завершено

Опублікований

almost 4 years ago

$10-30 USD

Оплачується при отриманні

Hello, need small help on VBA Macro code in excel. Task requires to import each text file into each individual cell of A column within Sheet1. Bulk import of text files into Sheet1 of Excel via VBA. Notes: All Text File Names are Different All Text Files are in the same folder There is 815 Text Files in 1 folder Each text file has anywhere between 500 words to 2500 words Each text file's content of 500 words to 2500 words has to be inserted into individual cell of Column A in Sheet1 In other words, we have 815+ articles in text files saved in 1 folder. We need to bulk import all 815+ Articles from Text Files into each individual cell within Column A of Sheet1. You will be responsible to have a small shared screen session with me to guide me to insert your VBA Macro correctly and to show me how to use it on shared screen session remotely.

Excel

Visual Basic

Visual Basic for Apps

Data Processing

ID проекту: 26422703

Про проект

8 пропозицій(-ї)

Дистанційний проект

Активність 4 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel developer currently at the post of Forum Expert at www.excelforum.com. I can easily write an Excel VBA script for you to scrape all the text files into individual cells on column A as you specified. Will be happy to guide you over a remote session in case you face any issues or need any assistance. I look forward to a positive and prompt response from your side. Regards Sourabh

$15 USD за 1 день

5,0

(149 відгуки(-ів))

6,1

8 фрілансерів(-и) готові виконати цю роботу у середньому за $19 USD

@AnowarRatul

----------------------------------------------------I CAN START RIGHT AWAY------------------------------------------------- Hello sir, I have read your project details and reviewed attachment understand clearly. I can VBA Excel Macro to Import Many Text files from Single Folder into Excel Sheet in each single cell in bulk by maintaining 100% accuracy of your data absolutely as you want. ------- VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting. I can start right now, please message me to discuss more. Regards, MA Hossain

$19 USD за 1 день

5,0

(128 відгуки(-ів))

5,5

@USAWebExpert

I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.

$20 USD за 7 дні(-в)

4,7

(6 відгуки(-ів))

3,8

@WycOj

--------------------I CAN START RIGHT AWAY------------------ EXPERT IN EXCEL Dear client, I can help you with your project of data entry in excel, VBA, excel macros, VB, building an excel file, excel dashboard, pivot tables, charts, v look up, word, database and Microsoft office at large since that is my area within your minimal budget and provide quality work within the time required, I can also provide samples, please consider my bid. Thanks of expertise

$20 USD за 1 день