×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to run *.ebm attachmate macro from VBA macro in excel

How to run *.ebm attachmate macro from VBA macro in excel

How to run *.ebm attachmate macro from VBA macro in excel

(OP)
Hi everyone, I hope someone can help me with the following issue.

I'm not a programmer but using the common sense I build some macros to interact excel with Extra! and viceversa (also reading lots and lots of threads).

The problem is, I need to run/execute 2 (two) attachmate macros (ebm) but I need to execute them from VBA code in excel, the macros are stored and "programmed" to run when the F4 and F11 keys are pressed and the Extra Session 1 is selected, I can to execute the F1, F2 and F9 without problems from the VBA code, I just need the SendKeys ("<PF1>") (or PF2 PF9) also this works with the "Enter", "Tab", etc. But when I try to do this with the F11 nothing happens. The F1, F2 and F9 are mapped as miscelaneous/send keys, but the F4 and F11 are mapped (in Extra!) as "Run macro" I'm stucked with this issue and this (I suppose) should be not too difficult to solve.

Any help will be REALLY appreciated.

Thanks in advance and best regards.

PS. My appologies english is not my native language and it is very poor. I hope my thread make sense to all.

RE: How to run *.ebm attachmate macro from VBA macro in excel

hi Robles74,
if I understand you correctly, you have F4 & F11 keys mapped on the keyboard to run a macro.
When you use Excel vba to call the F4 or F11 key, it will only perform the function that is specific to your mainframe. it will not run the macro that is mapped to the key.
you would need to either call the script directly or hard code the script into Excel. I don't know how to call the script directly. Hard coding should be as simple (depending on how complicated the script actually is) as copying the attachmate code into the Excel module.

hope this helps

RE: How to run *.ebm attachmate macro from VBA macro in excel

(OP)
Thank you remy988 I'll try your solution and tell you if that works.

RE: How to run *.ebm attachmate macro from VBA macro in excel

(OP)
My dear remy988, it works, I just need to do some minor changes in the *.ebm code and until now is running as is supposed to do. The question now is, what I need to do to close this question??

Thank you very much, I really appreciate your help.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close