I had attach the sample file for parallel data collection "test1" & "test2"(macro was create at excel 2010).
How it work:
1)once user update the data at "test1", the data will store at sheet 1 and "test2" file.
2)"test2" file won't display on screen, the screen just blink and auto close.
Problem now:
1) after "test1" update the data, the data will store at both of the file but the "test2" file can not auto close.
Hope can get consult for all the "GURU" at here.
Macro work out of sequence
Re: macro work out of sequence.
Your Macros written in Microsoft VBA. The MS VBA and the StarBasic+API functions of the AOO/LO are not compatible.
You must rewrite all of the macros if you want efficiently with AOO/LO.
Tle LibreOffice has a littlebit higher compatibility than the AOO has, but that compatibility value does not even approach the 100% value.
There are API functions for Opening an ODS document (or for open it silently), and there are API functions to Close it.
Please study the API descriptions and Andrew Pitonyak's free macro books.
You must rewrite all of the macros if you want efficiently with AOO/LO.
Tle LibreOffice has a littlebit higher compatibility than the AOO has, but that compatibility value does not even approach the 100% value.
There are API functions for Opening an ODS document (or for open it silently), and there are API functions to Close it.
Please study the API descriptions and Andrew Pitonyak's free macro books.
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.