Advertisement
Guest User

Untitled

a guest
Sep 8th, 2017
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. REM  *****  BASIC  *****
  2.  
  3. Sub Main
  4.     InSheet = thisComponent.Sheets(3)
  5.     OutSheet = thisComponent.Sheets(4)
  6.  
  7.     Dim r as Integer
  8.    
  9.     Dim out as Integer
  10.    
  11.     out = 1
  12.    
  13.     OutTest = OutSheet.getCellByPosition(1,0)
  14.     OutTest.String = "Hello world!"
  15.  
  16.     For r = 1 to 888
  17.         InURL = InSheet.getCellByPosition(0,r)
  18.         InMark = InSheet.getCellByPosition(9,r)
  19.         InTrust = InSheet.getCellByPosition(10,r)
  20.    
  21.         If (InMark.String <> "N/A" Or InMark.String <> "no") Then
  22.             OutURL = OutSheet.getCellByPosition(0,out)
  23.             OutSheet.getCellByPosition(1,out).String = "test"
  24.             OutSheet.getCellByPosition(2,out).String = InMark.String
  25.             OutURL.String = InURL.String
  26.             out = out + 1
  27.         ElseIf InTrust.String = "yes" Then
  28.             OutURL = OutSheet.getCellByPosition(0,out)
  29.             OutURL.String = InURL.String
  30.             out = out + 1
  31.         Else
  32.             OutURL.String = "Wrong"
  33.         EndIf
  34.         Next r
  35. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement