Search results for query: *

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>")...

What would cause a compile error on End Sub??????

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...

Also there are other Morbils on the Morbil screen that I am not concerned with. Only if they exist at 10,68;11,68;12,68 and so on.

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...

The problem is probably Do Until (MyScreen.WaitForCursor(3, 11)) maybe shoud be Do Until (MyScreen.WaitForCursor(3, 2))

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...

Sub Split() Dim NumbLines: NumbLines = 100 'or whatever Sheets("Sheet1").Select Sheets.Add Sheets("Sheet1").Select Rows("1:" & NumbLines).Select Selection.Cut Sheets("Sheet" & Sheets.Count).Select Rows("1:1").Select Selection.Insert Shift:=xlDown Sheets("Sheet1").Select Selection.Delete...

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...