Hi friends,
at my office I have to use Star Office 8.
I created a file in which I have several macros, one of these refers to the last sheet.
I've seen that when I insert a new sheet before the last one, the macro loses its reference to the last sheet.
Examining the macro, I can't actually see the references to the various sheets so I don't know what to change if I want to insert a new sheet and still have my macro working.
I attach the file, I hope someone can help me.
The macro I need to modify is ""Aggiorna_giacenza_monete_1_dopo_uscita".
Thank you very much,
Matteo,
Italy
[Solved] Help with StarOffice 8 macros
-
- Posts: 8
- Joined: Thu Dec 26, 2013 8:45 pm
[Solved] Help with StarOffice 8 macros
- Attachments
-
- CASSA 2.2 OpenOffice.ods
- (47.77 KiB) Downloaded 165 times
Last edited by Hagar Delest on Sun Jul 02, 2017 11:00 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OpenOffice 3.1 on Win Xp
Re: Help with StarOffice 8 macros
Hi,
the 9th sheet is here:
Means, if above .uno:JumpToTable the .value currently is 9, then, if you insert a sheet before sheet 9, it has to be 10. I found it twice in that code.
R
the 9th sheet is here:
Code: Select all
dim args3(0) as new com.sun.star.beans.PropertyValue
args3(0).Name = "Nr"
args3(0).Value = 9
dispatcher.executeDispatch(document, ".uno:JumpToTable", "", 0, args3())
R
- MMove 1.0.6
- Extension for easy, exact positioning of shapes, pictures, controls, frames ...
- my current system
- Windows 10 AOO, LOLinux Mint AOO, LO
-
- Posts: 8
- Joined: Thu Dec 26, 2013 8:45 pm