Macro work out of sequence

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
khphuah
Posts: 1
Joined: Sun Sep 10, 2017 7:09 am

Macro work out of sequence

Post 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.
Attachments
test2.ods
back up data
(12.5 KiB) Downloaded 115 times
test1.ods
Input data
(16.17 KiB) Downloaded 121 times
Open office 4.1.3
User avatar
Zizi64
Volunteer
Posts: 11352
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: macro work out of sequence.

Post 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.
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.
Post Reply