UbuntuGeezer wrote:focusing on this part of my query... The following statement:
oCat1Sheet = new com.sun.star.sheet.Spreadsheet
throws the error "Object not accessible. Invalid object reference."
...
What do I need to do to ensure that the runtime connects to the SDK objects? I can't find anything in the documentation about how to make this simple connection.

Thank you for the responses. I have used the same form as the example in response 2, just re-instantiating the object with the assignment statement into a var of type Object.
But I am curious as to why my proposed alternative..
Dim oCat1Sheet as Object
.
oCat1Sheet = new.com.sun.star.sheet.Spreadsheet
is throwing a runtime error.
I may be under the erroneous assumption that every time we use the oCat1Sheet = oSheets.getSheetByIndex()
method, any existing oCat1Sheet instance will be discarded, and a new instance created. It seems to me that it could be a bit more streamlined in the code to allocate oCat1Sheet as static (e.g. Static oCat1Sheet = new com.sun.etc), since I am using it in a sub that may have repeated calls to it and I would like the object to persist.
The piece I appear to be missing is WHERE OOoBasic obtains the .com.sun.star.sheet etc. definitions. My guess is that my Windows10 system is missing either an environment variable or PATH that the ooO Basic runtime is using to locate these definitions within the SDK. I checked the documents referenced with reply 1 and did not see anything that jumped out at me...
???
