Forum Discussion
temporalnaut
Jul 17, 2020Copper Contributor
File names from folders into rows and columns
Hi, please, in Libreoffice Calc I use the function of importing a list of files into the rows / columns of a Calc table, via Macro and based on certain criteria, which I describe below. Now I would n...
temporalnaut
Jul 18, 2020Copper Contributor
Yes it works, thank you. 🙂 Couldn't it be automated somehow? Compared to the Libreoffice solution, this is complicated. In LO, I have created a button on the toolbar for this particular macro, and after pressing it, I select a folder, and the list of images is immediately inserted into a new document.
OwenPrice
Jul 18, 2020Iron Contributor
If the steps above are saved into a workbook, you can set the steps to automatically refresh the output when you open the file. Go to Query tab, then Properties to configure the options.