I have a spreedsheet with data in 7500 Rows and columns A-M
I want to sort it by matching col C and D. In other words if C and D match move the row to the top. If they don't match, move the row to the bottom.
I don't think so. It's like a regular web site. I tried to use the mouse to copy something and when I right click the mouse it just says Silverlite. No menu pops up. It's a secure site and you have to log in and has several screens to go through before you find the one you want. This is...
Here is an example
' Global variable declarations
Global g_HostSettleTime%
Global g_szPassword$
Sub Main()
'--------------------------------------------------------------------------------
' Get the main system object
Dim Sessions As Object
Dim System As Object
Set System =...
We are linked to another departments terminal to retrieve data. They are going to a new web based system. I don't know if macros can work on a web site. Any ideas?
Thanks for the help Skip
This only works in attachmate!
When you copy something, it is put in a buffer. When you copyappend, it is added to the buffer as a seperate item. If I copy something then copyappend 3 more items, I have 4 items in the buffer. Then I paste the first item, then...
Quote:
from 1-4 lines
> line 10,67 numbers are at 10,69,10,77
> line 11,67 numbers are at 11,69,11,77
> line 12,67 numbers are at 12,69,12,77
> line 13,67 numbers are at 13,69,13,77
There are not always 4 lines of numbers on this particular screen.
Quote:
"Then I go to line 21,12 and...
Well I'm just learning. I don't have experience with If Statements and reviewing some posts on here I was trying to make something work.
I have a screen that has > 5326547
> 65479895
> 6587961
> 8567421
The screen could...
-----------------------------------------------------------------
' Global variable declarations
Global g_HostSettleTime%
Global g_szPassword$
Sub Main()
'--------------------------------------------------------------------------------
' Get the main system object
Dim Sessions As Object
Dim...
Shell "Notepad c:\My Documents\Print.txt"
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sendkeys "%{tab}"
Dim Sys As Object, Sess As Object, MyScreen As Object, MyArea As Object
Sess0.Screen.Sendkeys("<PF10>")...
Thanks Zach but this is going to be more complicated than I thought. I found out that on certain accounts (I don't know which ones but not all accounts) the programmers for our system made a popup screen. When putting an M on the first morbil and pressing enter, a screen pops up with a message...
The screen with Morbils shows there are other screens present.
I type an M on the first Morbile and hit enter which brings up the screen for that morbil. Copy the screen then PF3 back to the morbile screen then past the copied screen in the file. Put M on the second morbile press enter which...
I have no experience with If Statements. But I think I need one to accomplish this task unless there is another way to do it.
I have a specific screen that has "Morbiles" which is a > that is underlined. Placing the cursor on it and typing "M" and press enter brings up another screen that I...
play with this!
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
' MACRO NAME: CAPTUR32.EBM (update of 16-bit CAPTURE.EBM - using OLE Automation)
' WRITTEN BY: Attachmate Automation Support
'DATE WRITTEN: 2/29/96
' DESCRIPTION: This macro grabs an entire screen of...
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
' MACRO NAME: PRTSCR32.EBM (update of 16-bit PRINTSCR.EBM - using OLE Automation)
' WRITTEN BY: Attachmate Automation Support
'DATE WRITTEN: 2/29/96
' DESCRIPTION: This macro prints the host screen for the Active Session...
Usually you have to open an old macro in attachmate 7 macro editor and save it which usually automatically converts the old macro to the new format. Usually takes care of the problem. And attachmate has been known to change the path to the macros so check the folder path on your tool bar buttons...
probably pretty close to Excel VBA
SendKeys Method
See AlsoApplies ToExampleSpecificsSends keystrokes to the active application.
expression.SendKeys(Keys, Wait)
expression Optional. An expression that returns an Application object.
Keys Required Variant. The key or key combination you...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.