Reallt

That works perfectly! Thank you very much!

I am using this scrip to help an admin assistant in filling out a form. Right now we have 93 different clinics and they change all the time. This script will be grabbing the clinics from an up-to-date database, then filling in an input box on the form. I changed the line as was suggested; however I received the following error: Line 27 (File"C"\filelocation\script.AU3) SEND ($oRS.Fields(1).value) SEND ($oRS.Fields(1)^ERROR Error: The requested action with this object has failed. Thanks for the help!

I have a script that opens my database and collects infromation, but I havent been able to figure out how to send that information. Here is the code I have so far: ___________________________________________________________________ Local $oRS Local $oConn Local $oProviderGroupID $oConn = ObjCreate ("ADODB.Connection") $oRS = ObjCreate ("ADODB.Recordset") $oConn.Open ("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=user;Data Source=datasource") $oProviderGroupID = ObjName ("ProviderGroupID") $oRS.Open("SELECT DMisProviderGroup.ProviderGroupID FROM DMisProviderGroup WHERE DMisProviderGroup.Active= 'Y' AND LEFT(DMisProviderGroup.ProviderGroupID,3)IN ('LC.','MD.','UA.') AND DMisProviderGroup.ProviderGroupID NOT IN ('LC.PSYCH','LC.PSYKLR','LC.PSYMAD','LC.PSYMID','LC.PSYNEE','LC.PSYOSH')AND SUBSTRING(DMisProviderGroup.ProviderGroupID,4,3) <> 'LAB' ", $oConn, 1, 3) WinWaitActive ("MIS") For $iIndex = 1 To $oRS.RecordCount SEND ($oProviderGroupID) SEND ("{ENTER}") $oRS.MoveNext Next $oConn.Close $oConn = 0 ___________________________________________________________________ I know I am getting records, I can do a record count and it returns a value of 93 and that is correct. How do I print each record? Thanks!!!

I have looked at the Excel UDF, but I am still very unclear as to how to use it. I can find many examples of adding to an Excel, but so far have been unsuccessful in finding one where they are taking from the spreadsheet.

I would like to script in a lot of user information from a spread sheet into a web portal. I am able to script the portion to open the web site, login, and get the page to add information. What I dont know how to do is get the information from my Excel sheet into the portal. And how I cycle thru the records? Thanks for the assistance!