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?
Can I simultaneously write on notepad.exe with macro?
-
- Posts: 103
- Joined: Mon Sep 15, 2014 7:34 pm
Can I simultaneously write on notepad.exe with macro?
Win10-OpenOffice 4.1/LibreOffice 7.4
Re: Can I simultaneously write on notepad.exe with macro?
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?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Can I simultaneously write on notepad.exe with macro?
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.
OOBasic is similar to VB6 - but VB6 has a much bigger code base, where you can find solutions for things like your question.
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
Re: Can I simultaneously write on notepad.exe with macro?
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++.
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++.
Win7 Pro, Lubuntu 15.10, LO 4.4.7, OO 4.1.3
Free Project: LibreOffice Songbook Architect (LOSA)
http://struckkai.blogspot.de/2015/04/li ... itect.html
Free Project: LibreOffice Songbook Architect (LOSA)
http://struckkai.blogspot.de/2015/04/li ... itect.html
Re: Can I simultaneously write on notepad.exe with macro?
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?
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
Re: Can I simultaneously write on notepad.exe with macro?
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?Lupp wrote: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?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
-
- Posts: 103
- Joined: Mon Sep 15, 2014 7:34 pm
Re: Can I simultaneously write on notepad.exe with macro?
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.
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.
Win10-OpenOffice 4.1/LibreOffice 7.4
Re: Can I simultaneously write on notepad.exe with macro?
Create a TXT file
Open it through the shell with Notepad
Open it through the shell with Notepad
OpenOffice 4.1.12 - Windows 10