Dim oService As Object oService = createUNOService("com.sun.star.sheet.addin.Analysis") WkNum = oService.getWeeknum("2023-03-02", 1)
’ Does not work; “BASIC runtime error.” “Object variable not set.”
’ Called without any variables it says expects 3. Adding a 3rd gives same object variable not set error.
’ Have also tried a numeric date value.
’ Same parameters work in Calc =WEEKNUM(“2023-03-02”,1) function.
Spinning my wheels and not making any progress. Need your help please.
P.S. So glad there is a viable alternative to MSO. New computer and trying real hard to prevent MSO from ever touching it.