[Solved] Help with StarOffice 8 macros

[Dolphin975]

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

[F3K Total]

Hi,
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())

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

[Dolphin975]

Hi,
thank you very much!!!!