Recent content by kashford

Got it to work. Thanks for the help Skip.

I have a public sub routine that is called on startup that sets them as follows: Set System = CreateObject("EXTRA.System") Set Sessions = System.Sessions Set mySess = System.ActiveSession Set MyScreen = mySess.Screen I have tried the code as...

I am trying to port this sub routine over to Excel VBA from Extra basic Sub Move(ByVal value$, ByVal field$, ByVal enter As Boolean) Dim x As Integer, y As Integer x = Left(field, InStr(field, ",") - 1) y = Mid(field, InStr(field, ",") + 1, (Len(field) -...

It would be something like: If DlgValue.CheckBox1 = 1 Then Run Code End If

I have searched high and low for this, so I hope someone here can help. I am trying to automate a repetitive process of changing information on an IE form from a list in Excel. My problem develops when I need to select a value from a drop down list. I can not get Excel to loop through the...

This worked great. Thanks for the help.

I am trying to calculate a value to compare against a filed on our mainframe system. I can get the calculation to work correctly, but I am unable to round the value to two decimal places, but I just found out that the editor does not support the Round function. Does anyone have any ideas on...

I have a macro that reads an user supplied input file and then converts it to a formatted CSV file. My problem is that I can't find a command that will allow me to verify that the file name the users will enter into the macro is correct. I have tried several different variations of the...