I have the same issue. I would also note that when I early bind the SASObjectManager.ObjectFactory, the issue disappears. I can use: Dim obObjectFactory As New SASObjectManager.ObjectFactory
Dim obObjectKeeper As Object
Dim obServer As Object
Dim obSAS As Object
Set obObjectKeeper = CreateObject("SASObjectManager.ObjectKeeper")
Set obServer = CreateObject("SASObjectManager.ServerDef")
obServer.MachineDNSName = "sasmachine.sas.com"
obServer.Protocol = 2
obServer.Port = "1234"
'I can skip Set obSAS = CreateObject("SAS.Workspace")
'and go right to
Set obSAS = obObjectFactory.CreateObjectByServer("sas1", True, obServer, "username", "password")
obObjectKeeper.AddObject 1, "sas1", obSAS
obConnection.Open "provider=sas.iomprovider.1; SAS Workspace ID=" + obSAS.UniqueIdentifier With a reference to the ObjectManager checked and IOM unchecked. I am trying to switch to late binding for the same reason as the OP. The file offers additional value without connecting to SAS and not all users of the file are SAS users. I would also note that switching to late binding worked fine when I was using SASWorkspaceManager, however, since some users now have newer computers with only SAS 7.1, the WorkspaceManager doesn't work for them.
... View more