Can I simultaneously write on notepad.exe with macro?

[sokolowitzky]

Hello,

I already know how to export data from ods to txt files. That's not what I mean.
What I'm looking for is a simultaneous logging. I have thousands of files, they will be processed with the macro I already have set.
Now I only need one more thing, can I simultaneously write logs on notepad.exe(the classical one that is found in all windows os) ?
Like these
record 1: ...../xxx.ods is done
(a few secods later a new log appears on notepad's frame, without closing)
record 2: ...../xxy.ods is created

is this technically possible?

[Zizi64]

Now I only need one more thing, can I simultaneously write logs on notepad.exe(the classical one that is found in all windows os) ?

Has the Notepad.exe any API functions? Do you know them (if even they exist)?


You can launch third party softwares from an AOO/LO macro, but you can not control them if they have not some well described API functions.

I think it: you must handle that log file (database?) directly by the AOO/LO.
What filetype must be handled (that you want handle/fill by the notepad)? Is it a pure .txt/.csv,/.tsv file or other? Have you tried to handle it directly with the AOO/LO?

[JeJe]

If you type - visual basic 6 send text to notepad - into google it gives you some code.

OOBasic is similar to VB6 - but VB6 has a much bigger code base, where you can find solutions for things like your question.

[musikai]

I would recommend the notepad alternative Notepad++
https://notepad-plus-plus.org/
It allows to have a txt opened without being locked.
So you could export your logs into a txt file that is always opened in notepad++.

[Lupp]

I personally would avoid to depend on "third-party-software" in such a case. Why not write the logging data into an .ods sheet which later can be saved (exported) to plain text in .csv style?

[RoryOF]

I personally would avoid to depend on "third-party-software" in such a case. Why not write the logging data into an .ods sheet which later can be saved (exported) to plain text in .csv style?

Or modify the timed backup code to Save the document as plain text and intercept the Save function to cause the modified timed backup code to be used instead?

[sokolowitzky]

Thanks all for suggestions, informations...
The reason I prefer notepad is because this program uses very little of ram and cpu power. The sheets that I use have many complex formulas, like indirect&address, index&match, offset&range... so it takes a lot of power from the computer. So I thought if I can use the notepad it won't affect the main task's performance.

[Mr.Dandy]

Create a TXT file
Open it through the shell with Notepad