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

$10-30 USD

Completed

Posted

almost 4 years ago

$10-30 USD

Paid on delivery

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

Project ID: 26422703

About the project

8 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 1 day

5.0

(149 reviews)

6.1

8 freelancers are bidding on average $19 USD for this job

@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 in 1 day

5.0

(128 reviews)

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 in 7 days

4.7

(6 reviews)

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 in 1 day