Search results for query: *

Sub Main() Dim System As Object, Sess As Object, MyScreen As Object Set System = CreateObject("EXTRA.System") Set Sess = System.ActiveSession Set MyScreen = Sess.Screen varA = MyScreen.getstring(40,11,03) varB =...

Is there a way to tell the macro to Exit Sub if at any point there is an XStatus error of value 3 (typing in protected cell)? I can use an 'If statement' several times through the macro but I'd like to just use one statement at the beginning if possible. Thanks!

Okay, I've never messed around with arrays so I'm pretty ignorant to what can or can't be done with them. I have a list of over 150 different 'values' and I want to check and see if a certain string is any of those values. So I want to compare a string against these other 150 set values. Is...

I have a script set up to do a look up using a webpage search form and now I want to be able to have the macro search the page for the phrase 'No records match the criteria' but am unsure how to approach searching for text. Any ideas? Thanks!

I have searched extensively trying to find a solution to this but to no avail. I cannot seem to find how to pull information from Excel and place it into an already open form in internet explorer. I can find a hundred ways to open explorer, navigate to the url and input the data but that's not...

Recently our company started rolling out Citrix desktop clients to some of our employees in place of actual PCs. Would this change cause an error in the following code? The problem is only occurring with those who have switched to the Citrix client. Thanks! Dim Sys As Object...

I have programmed this type of command for IE in the past but am having problems getting it to work for Excel. I'm wanting to check to see if a particular file is already open. If it is open I want to activate it, otherwise I want to open it. Here is the code that I have used for IE, can you...

For whatever reason I'm having a block and can't figure out how to paste information that I have copied from Extra into a cell in Excel. Keep in mind, I'm not able to do this as a string, I am using the MyArea.Copy function and need to paste that into Excel. Set MyArea =...

I have a macro that is programmed to open up a web based form. Within that form is a drop down box with several options. Without the macro, when you select an option within that box with the mouse, the form will generate specific information based on what you have selected. My problem is, I...

1. Is there any way to limit the amount of characters that can be put in a textbox? 2. If so, is there anyway to have it 'auto-tab' to the next field when the one prior to it is completed? I'm guessing neither of these are possible as I have not found anything that even mentions it, but I...

Okay, I can activate the session I want with AppActivate but I can't get it to continue executing the macro in the other session. Here is what I have... Dim Sys As Object, Sess As Object, MyScreen As Object, MyArea As Object, i as Integer, oApp as Object, oWin as Object Set...

I currently have a macro that runs some commands in a session then opens internet explorer, performs a search from that page, and now i want to get it to go back to the session it was started in and continue to run. 1. Start in Attachmate Session 2. Pull Data 3. Open Internet Explorer to a...