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.
Attachments
test2.ods
back up data
(12.5 KiB) Downloaded 44 times
test1.ods
Input data
(16.17 KiB) Downloaded 53 times
Open office 4.1.3
khphuah
 
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; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; AOO4.1.5
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
Zizi64
Volunteer
 
Posts: 7989
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 3 guests