VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
(OP)
Hello,
Did anyone encountered and had a solution when trying to bind the Reflection Workspace 2014 in Excel VBA. I'm getting an error when creating a object. Saw a post on the related subject by sharonniles, however didn't saw the issue was resolved. here is the code below. Please help.
Dim oTerminal As Attachmate_Reflection_Objects_Emulation_IbmHosts.ibmTerminal
Dim oApp As Attachmate_Reflection_Objects_Framework.ApplicationObject
Dim oFrame As Attachmate_Reflection_Objects.frame
Dim oView As Attachmate_Reflection_Objects.view
Set oApp = New Attachmate_Reflection_Objects_Framework.ApplicationObject
If (oApp Is Nothing) Then
MsgBox "Unable to create Attachmate Workspace Application", vbCritical, "Application Workspace Error"
GoTo Obj_Release
End If
Set oFrame = oApp.GetObject("Frame")
If (oFrame Is Nothing) Then
MsgBox "Unable to create Attachmate Workspace Frame", vbCritical, "Workspace Frame Error"
GoTo Obj_Release
End If
Did anyone encountered and had a solution when trying to bind the Reflection Workspace 2014 in Excel VBA. I'm getting an error when creating a object. Saw a post on the related subject by sharonniles, however didn't saw the issue was resolved. here is the code below. Please help.
Dim oTerminal As Attachmate_Reflection_Objects_Emulation_IbmHosts.ibmTerminal
Dim oApp As Attachmate_Reflection_Objects_Framework.ApplicationObject
Dim oFrame As Attachmate_Reflection_Objects.frame
Dim oView As Attachmate_Reflection_Objects.view
Set oApp = New Attachmate_Reflection_Objects_Framework.ApplicationObject
If (oApp Is Nothing) Then
MsgBox "Unable to create Attachmate Workspace Application", vbCritical, "Application Workspace Error"
GoTo Obj_Release
End If
Set oFrame = oApp.GetObject("Frame")
If (oFrame Is Nothing) Then
MsgBox "Unable to create Attachmate Workspace Frame", vbCritical, "Workspace Frame Error"
GoTo Obj_Release
End If
RE: VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
Do you have a reference set to a Attachmate Reflections Object Library in your Excel VBAProject?
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
Thank you for looking into this.
Yes I do. Also, i have it installed.
It's already been a week and couldn't resolve this.
RE: VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
According to this link, you need FOUR Attachmate Reflections libraries to be referenced in Excel VBA.
Did you do this as well?
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
RE: VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
Caveat:
I am not an Attachmate Reflections user and never have been.
I am a former Attachmate Extra (AE) user. But I have done 99.99% of my AE coding in Excel VBA and I understand object concepts and working asynchronously with a terminal emulator.
If it helps any, here's the code I used to create an Attachmate System object (seems like its the application object...)
CODE
So for Reflection, maybe this...
CODE
Skip,
for a NUance!
RE: VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
RE: VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
Plz post the code that you tried with CreateObject.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
Set oApp = CreateObject(Reflection Workspace)
If (oApp Is Nothing) Then
MsgBox "Unable to create Attachmate Workspace Application", vbCritical, "Application Workspace Error"
GoTo Obj_Release
End If
RE: VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
Hmmmmmmm. Where's Workspace???
http://docs.attachmate.com/reflection/14.0/vbug.pd...
Here's what it seems to me. "Workspace" is a display thing, when you're working in Reflection.
However, you have stated that you'r running Excel usung VBA. What do you care what the workspace looks like? You just want to get data to get from Excel to your mainframe and data from your mainframe to Excel.
FORGET WORKSPACE!
Skip,
for a NUance!
RE: VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
...none of which, if I understand your intent, will affect data acquisition to or from the mainframe system.
http://docs.attachmate.com/reflection/16-1/vba-pro...
Skip,
for a NUance!
RE: VBA EXCEL ActiveX Component Can't Create Object in Reflection Workspace
I'm sorry was out for days. but here's what I understand. in order to access the frame I need to get the application itself by doing this.
Set oApp = New Attachmate_Reflection_Objects_Framework.ApplicationObject
or
Set oApp = CreateObject("Reflection Workspace")
however, none of this works.