Marie-Helene wrote:Thank you Lupp, this is very complete...
It isn't. It is a Q&D,
very quick and
very dirty piece of code I mainly made to chill.
It doesn't worry at all about expectable errors and lots of other things actually needing to be considered
before a program -even a very small one - can be developed.
I'm not a programmer and surely you are none.
Assuming you also don't want to learn programming: Either stick to the software you feel to know sufficiently, or change your strategy including the way you ask questions in a forum.
First learn some basics about the software you want to use from now on.
Consider then what you actually need and want to achieve by a limited project.
Describe it for yourself first - and find partial solutions (of which VBA code surely cannot be a part).
Then come to a forum and ask questions about what you couldn't accomplish on your own.
Let me exemplify it the fictional way:
I have text documents, mostly made with (software / scanner+OCR, ...)...
They contain lots of mostly useless or badly implemented formatting, objects of any kind, comments of no value...
I want to strip them down to get pieces of pure text which I can later use as modules when composing new documents.
The typical size of such a documnt is 5000 by word count, and the typical number of pieces I want to get from one of them is 25. (An average of 200 words per module.)
I can accept the huge lot of files I would get if one file per module is created, but I am interested in better solutions probably suggested.
A nice idea would be a system managing the modules in a way providing easy means for searching.
Of course, the typical MS idea of "firts line as filename" must be ruled out.
...
...
This will not be what you actually wanted to ask, but it shows a kind of asking being really useful for somebody spending his (f/m) time to consider recommendable solutions.
It
may be that the solution you end up with actually requires some custom code. If so, this code
surely must be of better quality than the Q&D piecees already posted.
There is a majority of questions in a forum like this one, of course, that are much shorter, addressing one technical point, and expexting also a short answer. Guidance concerning complex projects isn't the main strength of the forum way to get help.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München