• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

Page Up key

The normal commande I use for VBA Excel interacting with Extra is "<ENTER"> for example. How do I recplicate the Page Up key? Nothing seems to work
0
macrohappy
Asked:
macrohappy
  • 9
  • 5
  • 4
  • +1
1 Solution
 
bruzieCommented:
Use:
ActiveWindow.LargeScroll Down:=-1

Open in new window


(ActiveWindow.LargeScroll Down:=1 gives you PageDown)
0
 
macrohappyAuthor Commented:
Isn't there a simple SendKeys command. I am not looking to scroll I want to utilize the Page Up Key by using a SendKey command
0
 
macrohappyAuthor Commented:
I should clarify that I am interacting with Excel VBA and Attachmate Extra 9.1
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
bruzieCommented:
In which case this should do the trick:
Application.SendKeys("{PGUP}")

Open in new window

From: http://msdn.microsoft.com/en-us/library/aa202943(v=office.10).aspx
0
 
macrohappyAuthor Commented:
Doesn't work the only format I can get to work for Attachmate is Application.SendKeys "<Enter>".
Application.SendKeys "<PGUP>" or Application.SendKeys "<Pageup>" doesn't work
0
 
macrohappyAuthor Commented:
I got it the format for the pageup key is  Application.SendKeys "<Pa1>>". Thnaks for trying
0
 
dlmilleCommented:
It wasn't a try.  It works, my friend.

Here - see it in code:

Put this in your workbook - page down a bunch, then run this macro from Developer's ribbon.

Sub test()
    Application.SendKeys "{PGUP}"
End Sub


And when you get a link from a bonafide source like http://msdn.microsoft.com, you might want to try to understand perhaps what could have gone wrong when you test.


Cheers,

dave
0
 
dlmilleCommented:
Remember to use CURLY braces :) if that could make a diff.

:)

Dave
0
 
patrickabCommented:
>The normal commande I use for VBA Excel interacting with Extra...

What is Extra?
0
 
patrickabCommented:
macrohappy should not be awarding himself the answer if he has been helped.

If a co-worker has helped then that person should be awarded the appropriate grade and points.
0
 
macrohappyAuthor Commented:
I would gladly award him the points but he is not a meme of this site. Not sure what the big deal is I just so happen to get help elsewhere, so harm no foul. These point things don't mean anything to me
0
 
patrickabCommented:
>These point things don't mean anything to me

In other words you couldn't care less about those that help you - even though they are not paid to do so and the only way in which you can show your appreciation on this website is by awarding points and a grade.

Because you pay for membership does not exempt you from knowing how this website works nor from recognising help when you get it.
0
 
macrohappyAuthor Commented:
If you notice I have submitted 18 previous questions and have awarded 500 points everytime. You tell me who should I reward the points to even though the solution didn't help? Points for trying is that what you are after?
0
 
patrickabCommented:
>Points for trying is that what you are after?

No, I have never suggested nor expected that. It's just that your original reason for closing the question did not make sense. But each to their own.

Meanwhile I don't even see the point of your question - but then that's just me.
0
 
macrohappyAuthor Commented:
I am not trying to be a jerk and I hold a lot of respect for people like yourself that understand VBA as well as you do, that is why I have a membership. For some reason the standard code for SendKeys does not work for me I have to use an alernative format. If you can tell me why I would be more than happy to accept your solution and award the points.

I have to use "<Enter>" instend of "{Enter}" and now I had to use "<Pa1>" instead of "{PGUP}". I have no idea why the standard format does not work. The macro runs a Terminal Emulator called Attachmate Extra. Maybe there is some settings in the TE, I don't know.
0
 
patrickabCommented:
macrohappy,

First run this:

Sub redirect()
Application.OnKey "{PGUP}", "Attachmate Extra"
End Sub

Subsequently PgUp will start Attachmate Extra if that's what you call to start Attachmate Extra".

Patrick
0
 
dlmilleCommented:
I did some research and apparently Attachmate Extra has special keys that it uses, and those special keys can be found in the Extra Basic help files.

Here's a link:  http://www.tek-tips.com/faqs.cfm?pid=99&fid=4087

Dave
0
 
dlmilleCommented:
These can be used with the SendKeys command in VBA against an Attachmate Extra application, per the FAQ

Dave
0
 
macrohappyAuthor Commented:
I received a helpful answer
0
 
macrohappyAuthor Commented:
Exactly what I have been searching for. Thanks for the link. In addition to the < > issue I also found that my keyboard had my Page Up key mapped as a PA1 key
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 9
  • 5
  • 4
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now