Hello. I'm currently working in OpenOffice Calc, and I often have to print more than 40 files at once. Select all, PCM, printing does not work for me. Tell me, please, can there be a macro that allows you to print all the files in the same folder in which the file is located, where does this macro run from? I used to work in Excel, but at work only OpenOffice is installed, so now I'm working on it. If I know more or less excel macros, then I do not understand anything in OO macros. Help me please.

Not the answer, just a little explanation: when OOKapitan writes "PCM", he meant the right click of the mouse

I may not have a lot to give but what I got I'll give to you...Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7If you think that I did not answer your question, make allowances for my imperfect English

Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.PortableApps/winPenPack: LO3.3.0-6.4.3;AOO4.1.7Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.

With respect, you want it, you write it. I don't need to print files in such a way. I've already done some research for you and the process now should now be achievable using your existing skills gained from writing Excel macros,

Change PrinterName to your printer name only if you do not want to use the default printer.

Change D:\Data\PrintDocs\ to the directory where you keep the files you want to print. If you only want to print Calc spreadsheets, change *od? to *.ods then all the spreadsheets in the directory you have named will be printed.

Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.PortableApps/winPenPack: LO3.3.0-6.4.3;AOO4.1.7Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.

Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.PortableApps/winPenPack: LO3.3.0-6.4.3;AOO4.1.7Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.

Here's what I got. But: 1) it prints out from the directory c:\printpath, but I would like the macro to let me select a folder or to print out from the same folder the macro is in (to select the folder would be better); 2) after each document asks whether it is printed or not, but I would like the macro after selecting a folder just to print all files in it. Also it would be better if the macro could print only files with the extension xls. Help me please.

Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.PortableApps/winPenPack: LO3.3.0-6.4.3;AOO4.1.7Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.

I tried. The macro allowes me to select the folder, but prints nothing. I forgot to say that the files must be opened visibly or they won't be printed.

Really, the usage of the filepicker is only the first part of the full macro what you needed. Then you must open (LoadFromURL...) the documents one by one (silently or visible) based on the picked path and the DIR strings as filenames, and then you will able to use the Print command of the API.

Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.PortableApps/winPenPack: LO3.3.0-6.4.3;AOO4.1.7Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.

I tried. The macro allowes me to select the folder, but prints nothing. I forgot to say that the files must be opened visibly or they won't be printed.

Really, the usage of the filepicker is only the first part of the full macro what you needed. Then you must open (LoadFromURL...) the documents one by one (silently or visible) based on the picked path and the DIR strings as filenames, and then you will able to use the Print command of the API.

I do not no how to do this. Macro on the OpenOffice is a forest to me. I managed to write the macro I inserted two posts above by using parts of macro I found in the internet. In excel to write macro I in minimum just need to understand english. For macro in OpenOffice it doesn't work. Please help me to write full macro.

Try to write a macro, upload the working example here, and we will (try to) fix your mistakes.

In excel to write macro I in minimum just need to understand english. For macro in OpenOffice it doesn't work.

Try the LibreOffice. It has a higher compatibility with the foreign fileformats and the MS VBA macros.

Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.PortableApps/winPenPack: LO3.3.0-6.4.3;AOO4.1.7Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.