Page 1 of 1

Macro work out of sequence

PostPosted: Sun Sep 10, 2017 7:54 am
by khphuah
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.

Re: macro work out of sequence.

PostPosted: Sun Sep 10, 2017 9:37 am
by Zizi64
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.