I have this figured out but would like to know if this is the best way to go about doing this? Here's what I desire...say I am on sheet 9 and I want to go to sheet 46 in my design. Here's what I have done in my VBScript to accomplish this:
' get the schematic name
schName = vdapp.GetProjectData.GetiCDBDesignRootBlock(vdapp.GetActiveDesign)
Set oSchematicSheet = vdapp.SchematicSheetDocuments.Open(schName, sSheetNumber)
where sSheetNumber is the sheet to be opened i.e. 46 in this example
Yes, that's the best way. You might want to put in some error checking to make sure the sheet number is in range of actual sheet numbers, but the basic function is right.