Excel VBA Macro to Open File and Insert Row on a Loop

We need a VBA Macro which will loop through a list of Excel files and perform the following functions: Open the file, insert a row between rows 1 and 2 (below the first line), save the file, close the file, move to the next. It should be very easy and take less than an hour. The attached files are samples, so we need the code to be generic enough that we can modify the same sheet/macro to insert/delete rows as needed when the system that creates the files changes their formatting.

Evner: Excel, Visual Basic, Visual Basic for Apps, Databehandling

Se mere: excel vba create data file, excel vba data mpp file, excel vba import multiple file worksheet, excel vba directory tree file list, excel vba save image file, solidworks macro open file dialog, excel vba import text file chart, excel vba outlook email file, vba connection open file csv delimited semicolon, excel vba generate xml file, excel vba write unicode file, excel vba cut paste file, excel vba rewrite existing file, excel vba save text file, excel vba check valid file name, excel vba convert open office, excel vba custom xml file, excel macro open file

Om arbejdsgiveren:
( 0 bedømmelser ) Phoenix, United States

Projekt ID: #21441497

Tildelt til:


Hello there, I can write macro for this task. I have just one query . Do you need this macro to ask for folder selection that contains the excel files.

$15 USD på 1 dag
(4 bedømmelser)

9 freelancere byder i gennemsnit $20 på dette job


Hi, yes this is not hard to do and yes it can be done under an hour. If you are interested in working with me, please message me, i have few follow up questions. I am able to start immediately. Thanks, Milan

$20 USD på 1 dag
(504 bedømmelser)

I can do it for you quickly and exactly .Please contact me for saving your time and your money .

$30 USD på 1 dag
(123 bedømmelser)

Dear client I understand the scope of work involved in the project. I can write the code for you in 30 mins. Please contact me. Roy

$25 USD på 1 dag
(327 bedømmelser)

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible Flere

$20 USD på 1 dag
(114 bedømmelser)

Hi https://www.freelancer.in/u/Mokshith30?w=f I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous Flere

$30 USD på 1 dag
(37 bedømmelser)

Hi, I have understand the project requirement & interested to make for add and delete row for this project. Please send a message so we can discuss more & start the project. Thanks.

$20 USD på 1 dag
(23 bedømmelser)

hi sir i read it and i get all you want very well and i am ready to start right now i am a fluent English speaker and i will get the job done in the dead line i will do it soooo carefully to not having any mistakes Flere

$10 USD in 4 dage
(0 bedømmelser)

Dear Hiring Manager The VBA Macro will be created which will loop through a list of Excel files and will perform all the required functions as mentioned above. This project will take less then one day. I have good grip Flere

$14 USD på 1 dag
(0 bedømmelser)