Can anyone recommend a good guide to macro writing please?
In the mean time, after a few hours of fruitless research where many of the code examples I found gave me Basic 'syntax errors, I found how to open a calc sheet using Doc = starDeskTop.loadComponentFromUrl (Url, "_Blank", 1, Array()). That should have been so easy to find!
Now I wish to work on the opened sheet, and I do understand that unlike VBA, OO requires I activate the sheet EACH time I need to do so - but can I find how to make a sheet active? No.
VBA Code:
Code: Select all
Workbooks(openfile).Activate
Worksheets(sheetname).Activate
While I am posting, please, I need to autorun a macro which will populate a listbox 'Listbox1', on a Dialog 'Dialog1' with an array
Code: Select all
MyArray2 = Array("WHOLE YEAR", "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER")