Open office 3.1.1 macro

VERY IMPORTANT: The macro must work with Open office version 3.1.1 !!! It`s not the same thing as code it for excel!

What I manually do now and needs to be automatically done:

- open my main file;

- open several other files called "target files" (similar files, data is different);

- copy row21 from each of the files and "paste special" it in the main file. repeat with each of the "target files". close target files. Open the next ones. repeat.

Need to do this without opening the files (less time) if possible. If not, only auto.

So I will need a simple macro that will open the "target files" and copy the same row and paste it "special" in the main file, always in the same sheet but in the next empty row. I must be able to select the "target files" so I can remember which files I already processed. (using a keyboard shortcut which allows me to open a dialog and select and open multiple files by CTRL+click; multiple means 5-10 at once)


"target files" =files from which I copy row21

"main file" =file where I paste the data copied

Copy always row21 from sheet named "basketball stats". Paste will be made in sheet3 of the main file starting with the 9th row. Paste special, only "text" and "numbers" checked. (MAIN file attached here already has the data from the 5 target files, as an example).

Target files and Main files will have different filenames; files in here are only an example. Sheet names inside them will always remain the same as they are.

Taidot: Excel Macros

Näytä lisää: convert open office, download open office database report addon, convert open office pdf, what is open office 2018, open office 3.4 1, how open office works, open office youtube, open office versions, how to open office in windows 10, open office tutorials, open office 4.1 1 download, open office calc macro java example, run excel macro open office calc, open office calc excel macro, open office macro convert linux, macro converter doc open office, open office calc java macro, maker macro open office calc, open office macro excel, run excel macro open office

Tietoa työnantajasta:
( 3 arvostelua ) Timisoara, Romania

Projektin tunnus: #18905223

Myönnetty käyttäjälle:


Automation to copy the same line from many different files and paste as special (only values and without format) to the main spreadsheet, always changing to the next line avoiding overwrite. Result of 10 source spread Lisää

€9 EUR 2 päivässä
(0 Arvostelua)

I can help you I think, I can figure out your problem. I have rich experience in excel and VB, and I do my best to save your time and pocket. please feel free to contact me. MySkills: • Data Management .......... Lisää

€30 EUR 1 päivässä
(3 Arvostelua)

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


Hello, I have OpenOffice 4.1.6. To be honest I don't know if there will be any issues with your older version but considering that the code is not very out of the ordinary, it should be fine. I can build the macro Lisää

€40 EUR 1 päivässä
(5 arvostelua)

bonjour , je suis disponible et efficace vous pouvez compter sur moi pour faire l travail comme il faut et merci d'avance

€23 EUR 10 päivässä
(0 arvostelua)