Trouble With Excel 2010 And Bartender 10 Follow
I've been trying to use an Excel spreadsheet to use a number inputted from the Data entry form to search through one column and return from the next column the same record line. When I run a print preview,it returns only the top record of the column. I've tried using a VBScript, Excel functions, all with the same result. Below is the script I've been trying to use as well as the label. Any help would be greatly appreciated.
If Field("Sheet3Fabric$.Mil 1")= Field("Sheet3Fabric3$.Mil 2") Then
loopCount = 3
Do while not isempty(objExcel.Cells(loopCount, 1).Value)
For i = 7 To 8
value = CurDir(loopCount, i).Value
loopCount = loopCount + 1
If("Sheet3Fabric$.Mil 1")= Field("Sheet3Fabric$.Mil 2")Then
value = value
objExplorer.document.body.innerHTML = value
Fernando Ramos MiracleModerator
Please sign in to leave a comment.