Macro work out of sequence

Creating a macro - Writing a Script - Using the API

Macro work out of sequence

Postby khphuah » Sun Sep 10, 2017 7:54 am

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.
back up data
(12.5 KiB) Downloaded 47 times
Input data
(16.17 KiB) Downloaded 56 times
Open office 4.1.3
Posts: 1
Joined: Sun Sep 10, 2017 7:09 am

Re: macro work out of sequence.

Postby Zizi64 » Sun Sep 10, 2017 9:37 am

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; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.3;AOO4.1.7
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.
User avatar
Posts: 9193
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Return to Macros and UNO API

Who is online

Users browsing this forum: jeevanthara and 7 guests