Add in for autECLMacro "[edit-copy]" in Excel VBA

[laks143]

hi
I am trying to Copy Mainframe screen and paste it in to Word document.I am getting an error like autECLMacro Sub or Function not defined.
Here is my code

Dim word
Dim autECLSession, autECLPS, autECLOIA
Set autECLSession = CreateObject("PCOMM.autECLSession")
Set autECLPS = CreateObject("PCOMM.AutECLPS")
Set autECLOIA = CreateObject("PCOMM.AutECLOIA")
autECLSession.SetConnectionByName ("A")
autECLMacro "[edit-copy]"
Set word = CreateObject("Word.Application")
word.Visible = True
word.Documents.Add
word.Selection.Paste ("\endofdoc")

Please help me can any one knows..

Thanks in Advance!!

 

[HarleyQuinn]

As I have no idea from the code what autECLMacro is meant to be (you don't seem to use it anywhere), I'm going to assume it needs the value assigned to it rather than the way you currently are (you're using it like a sub or function at the minute as the error says):

autECLMacro [red]=[/red] "[edit-copy]"

Hope this helps

HarleyQuinn
---------------------------------
Black coat, white shoes, black hat, cadillac. The boy's a timebomb!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before post