VBA for mainframes

[poojakhade]

I am a mainframe professional,new to VBA.I am trying to develope a MACRO in VBA to copy from EXCEL and paste on mainframe online screen.I am getting the error while compiling that can't find project or library.
Below is the code I am usein.Do i need to install anything more to execure this sode?


Sub Update_RAN()
On Error GoTo ErrorHandler

'Set up interface to Emulator
Set autECLConnMgrObj = CreateObject("PCOMM.autECLConnMgr")
Set autECLOIAObj = CreateObject("PCOMM.autECLOIA")
Set autECLSessionObj = CreateObject("PCOMM.autECLSession")
Set autECLPSObj = CreateObject("PCOMM.autECLPS")
autECLOIAObj.SetConnectionByName ("A")
autECLPSObj.SetConnectionByName ("A")

 

[pbornemeier]

When working with objects that are not in the Excel library, you have to reference the .dll, .ocx, .exe, .tlb, .olb (and other extensions) file that contains references to those objects that Excel can use.

In the VBA editor, select Tools | References and either find the appropriate file in the list and put a check next to it or use the Browse... button to find it.

Excellent discussion here:
http://www.cpearson.com/excel/missingreferences.aspx

 

[poojakhade]

thanks...the site helped me a lot