Excel to Attachmate

[CharlesDH]

HI,

I'm new to this forum, and in need of some information.
I'm trying to help a friend write a marco in Excel to interface with Attachment. From this forum I've found what I thought would work. However when trying to use the codes found I receive an error when trying to create and object.
Ie:
Set System = CreateObject("EXTRA.System")

This produce an error 429. I check Excel Ref. Lib for the lib.
but could not find one. Is there a add in or something else that I may need, or is it something in the Ref. Lib thats not obvious to me.

I'm using Office 2003 pro.
Window xp.

Thanks.

 

[SkipVought]

Try Attachmate Extra! n.m Object Library

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[CharlesDH]

Skip,

Thanks for the reply, however I should have stated that I'm looking for the Object Library in Excel. Also I do not have Attachmate Extra and I'm not sure if I need it to create a code in Excel. I do know that when trying the codes I found on this forum in Excel it ask for the Obj.Lib in Excel.

Once again thanks, and hope to hear from you.

Charles

 

[SkipVought]

In Excel's VB Editor Tools > References to find this reference.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[CharlesDH]

Skip,

Once again thanks for the response. I did check the Excel VB Editor tools Ref. But I did not find a Ref for Attachmate or Extra. Is it under another name?

Charles

 

[SkipVought]

Then you probably do not have the library.

Do you have Extra!Personal Client installed on your PC?

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[CharlesDH]

Skip,

Thanks again. I do not have any type of programs for attachmate. So I'm assumming by your question I may need it.

From the info I gathered on the forum you can go from Attachmate to excel, but now I get the impression you can not go from Excel to attachmate because of the Object Lib. is not in Excel.
If thats the case is there is there a download that will allow me to use Excel to Attachment?

Charles

 

[SkipVought]

Why would you want to if you did not have an Extra!Personal Client Emulator? You have NOTHING to go to or from.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[CharlesDH]

HI,

I was attempting to help a friend who wanted a macro in EXCEL to work with attachmate. Also I found code within this forum that shows a macros in Excel Vb here's part of the code.
This code I assumed was an Excel code. How ever I get the error for "CreateObject" error 429. Which I took as needing the Attachmate object in the Excel Lib.

Global g_HostSettleTime%
Global g_szPassword$
Public Sessions As Object
Public System As Object
Public Sess0 As Object
Public System As ExtraSystem
Public Sessions As ExtraSessions
Public Sess0 As ExtraSession
Public MyScn As ExtraScreen



 Sub Main()

'--------------------------------------------------------------------------------
Dim Sessions As Object
Dim System As Object
Set System = New ExtraSystem
Set Sessions = System.Sessions
Set Sess0 = System.ActiveSession
Set MyScn = Sess0.Screen
Set System = CreateObject("EXTRA.System") ' Gets the system object
If (System Is Nothing) Then
MsgBox "Could not create the EXTRA System object.  Stopping macro playback."
Stop
End If
Set Sessions = System.Sessions

 

[SkipVought]

    Set oSystem = CreateObject("Extra.System")
    
    Set oSess = oSystem.Sessions.Open([i]path&filenameforextraapplication[/i])

    Set oScrn = oSess.Screen


Skip,
[sub]
[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
[b]Small Medium at Large[/b][tongue][/sub]

 

[CharlesDH]

Skip,

Once again thanks for the reply. I tried your suggestion, however Excel is still looking for the "Extra" object Lib.
Do you know if there is a active x componet or .dll that could be used?
If not then I guess I'm up the creek with out a paddle.

Charles

 

[SkipVought]

Ahhhhhhhghhhhhh!

You don't have Extra!Personal Client loaded on your PC, by your own admission.

Load the Extra!Personal Client!!!

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[CharlesDH]

Skip,

Hope you have a great New Year. Thanks for the quick response. Now, however I do not have either "AttachMate" or the "Extra!Personal Client" So unless I get the sofware involved I guess like I said "Up the Creek".
I'm also checking the "Attachmate" corp. site to see if they also may have a soultion.

Charles.