×
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

Extra macro example

Extra macro example

Extra macro example

(OP)
Good evening,

I know little about VBA, and I need to create a macro to help me extract data from MyExtra and paste it into an excel sheet to avoid repetitive work. Will you have a basic example that allows me to extract data from page "X" of My Extra and paste it into cell A1 of Excel Sheet 1?

I want an example so I can compile and understand the basics.

Thank you very much to all

RE: Extra macro example

FreCard,

Unfortunately, my library of Excel VBA for Attachmate got lost.

During my career, I got lots of requests from various people a developed a method to take a list of lookup values in Excel and perform an Inquiry for each value, COPY an entire screen and then create a table of values for the Fields and Data corresponding to each value. BTW, the reason I did this is because I saw that other people had written separate programs for many different screens and I said to myself, "Why couldn't I make ONE program that I could use to scrape ANY screen and put ALL the data into an Excel sheet?" So that's what I did. I used a Screen Description Table FAQ99-7950: Strategies for scraping in multiple screens

I did this entirely in Excel VBA, with a reference to the Attachmate!Extra Library. This is not a trivial task. I developed about a dozen custom functions and procedures. It took weeks to develop while I was performing other required tasks.

How conversant are you with Excel VBA? I would NOT recommend coding in Attachmate VBA in order to screen scrape to Excel. Excel is The Place to put your effort. Attachmate you will use infrequently. Excel you will find more and more useful. Attachmate VBA is like driving a Yugo. Excel VBA is like driving a Jaguar.

Check the FAQ for Attachmate posted here. There are code examples that you can use in Excel VBA, given that you go to Tools > References in the Excel VBA Editor, and add a reference to the Attachmate Objects Library.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

RE: Extra macro example

(OP)
Hi!
If I have knowledge of VBA Excel.
So I want to start developing the code in Excel.
My PC has Windows 10 x64, my Excel is 64-bit.
Would you have a problem?
Do you have any recommendations to be able to start the code and connect Excel with MyExtra?

RE: Extra macro example

Did you attempt to
1) view the FAQs in this forum?
2) add a reference to Attachmate Object Library in the Excel VB Editor?
3) use the code you found in the FAQs to test grab your emulator screen object?

You're gonna have to experiment A LOT! You can get Microsoft VBA help at forum707: VBA Visual Basic for Applications (Microsoft). I post there, so I'll see your questions if I'm around.

Learn to use the Watch Window to discover what properties and values you have as you run your code at various times. FAQ707-4594: How to use the Watch Window as a Power Programming Tool

I think I remember being able to get a Help menu for the Attachmate VBA Properties & Methods but I can't remember where. That will be essential. You might need to google.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

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