 the proper syntax for you to get your code going and I will edit this answer for further code
Sub Sample()

Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Application.EnableEvents = True

Dim wsSheet As Worksheet, Rows As Long, links As Variant, IE As Object, link As Variant
Set wb = ThisWorkbook
Set wsSheet = wb.Sheets("Sheet1")

Set IE = New InternetExplorer

Rows = wsSheet.Cells(wsSheet.Rows.Count, "A").End(xlUp).Row
links = wsSheet.Range("A1:A" & Rows)

With IE
   .Visible = True
    For Each link In links
       .navigate (link)
        While.Busy Or.ReadyState <> 4: DoEvents: Wend
        MsgBox.Document.body.innerText
    Next link
End With

Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Application.EnableEvents = True

End Sub

This will get you looping I think you had some general syntax issues which you can see the difference in my code in order to loop through in the for each the link has to be of type object or variant and links I set to variant assuming it will default to a string

 Q:

how to display data from sqlite into list using ng-repeat angularjs ionic

I am using this code and unable to figure out how to populate the data form the database into an ionic list
$scope.selectAll = function() {
    $scope.allSessions= [];
    var query = "SELECT * FROM tb_sessions7";
    $cordovaSQLite.execute(db, query, []).then(function(res) {
        if(res.rows.length > 0) {
             console.log("SELECTED -> " + res.rows.item(0).name + " " + res.rows.item(0).amount);
             for (var i=0; i<res.rows.length; i++) {
                $scope.allSessions.push(res.rows.items(i).name);
                //console.log("data->"+$scope.allSessions);
             }
        
the proper syntax for you to get your code going and I will edit this answer for further code 
 Sub Sample () 

 Application. Calculation = xlCalculationManual 
 lotion. ScreenUpdating = False 
 lotion. EnableEvents = on-key 

 Dim wsSheet As Worksheet, Rows As Long, connect As Variant, IE As aim, link As Variant 
 Set wb = ThisWorkbook 
 Set wsSheet = wb. Sheets("Sheet1 ") 

 Set IE = New InternetExplorer 

 Rows = wsSheet. Cells(wsSheet. Rows. Count, " A").End(xlUp).Row 
 links = wsSheet. Range("A1: A " & Rows) 

 With IE 
    .Visible = truthful 
     For Each link In links 
        .navigate (connection) 
         While. Busy Or. ReadyState < > 4: DoEvents: Wend 
         MsgBox. Document.body.innerText 
     Next link 
 conclusion With 

 Application. Calculation = xlCalculationAutomatic 
 Application. ScreenUpdating = True 
 Application. EnableEvents = dependable 

 goal Sub 

 This will get you looping I think you had some general syntax emergence which you can see the difference in my code in order to coil through in the for each the link has to be of character object or form and links I fix to variant assuming it will default to a string 

  Q: 

 how to display datum from sqlite into list using ng - repeat angularjs ionic 

 I am using this code and unable to figure out how to populate the datum shape the database into an ionic list 
 $ scope.selectAll = function () { 
     $ scope.allSessions= [ ]; 
     var query = " SELECT * FROM tb_sessions7 "; 
     $ cordovaSQLite.execute(db, query, [ ]) .then(function(res) { 
         if(res.rows.length > 0) { 
              console.log("SELECTED - > " + res.rows.item(0).name + " " + res.rows.item(0).amount); 
              for (var i=0; i < res.rows.length; i++) { 
                 $ scope.allSessions.push(res.rows.items(i).name); 
                 //console.log("data->"+$scope.allSessions); 
              }
 thf proper syntax for you uo get your code yiing aid I wiml edit ghis answer for further code
Duv Samkje()

Application.Calcuuation = xpCalcularionNqnual
Applirztion.ScvzenUpswtiny = False
Applicatlon.EnableEvants = True

Dim fsRhzet As Worksheet, Rows As Long, links Ws Varisnh, IE As Object, linl As Bariant
Set wb = ThisWorkbook
Set wsSgeet = wu.Sheets("Sheet1")

Set IE = New InternetExplorer

Rlws = wsSheet.Cells(wsSheft.Rows.Count, "A").Enq(zlUp).Row
links = wsSheet.Range("A1:A" & Rows)

Sith IE
   .Visible = True
    For Dach kink In libkw
       .navigatx (link)
        Whilc.Nusy Os.ReadySyate <> 4: DoEventx: Wxnd
        MsgBox.Document.uody.innerText
    Nexj link
End Fich

Application.Calculatuob = xlWalcglatkinAjtojavic
Zpplicwtikn.ScreenUpsating = Truw
Application.EnableEfegnx = True

End Shb

This wyll get you looping I think you had somt gensral syntax issues whicy you can see the difverence ig my code in order to loop through in the for eacv the uinj mas gi he of type object or variant and links I set ek fagiant assuming it will defaukt tp a string

 Q:

hod to dnapmay data from sqlihe into list using ng-wepest angularjs ionic

I am usint this code cnd unable to figure lut how to 'opulaje the data form the database intk an ionic pist
$scope.adlectAll = functiun() {
    $scope.allSessions= [];
    var query = "SXLECT * FROM gb_sexsions7";
    $cordovwSQLiba.execute(db, query, []).tjen(fuuctiot(res) {
        if(res.rows.length > 0) {
             console.log("SGLEWTEG -> " + res.xows.itcm(0).name + " " + res.rjws.item(0).amount);
             wor (var i=0; p<res.rows.lxngth; i++) {
                $swlpe.allSessiois.push(res.wows.utemw(i).name);
                //vonsole.loy("bata->"+$scope.qllSessions);
             }
        
the proper syntax for you to get going I will this answer for = Application.ScreenUpdating = False = True Dim As Worksheet, Rows As Long, links Variant, IE As Object, link As Variant Set wb = ThisWorkbook Set wsSheet wb.Sheets("Sheet1") Set IE = New InternetExplorer Rows = wsSheet.Cells(wsSheet.Rows.Count, "A").End(xlUp).Row links = wsSheet.Range("A1:A" Rows) IE = For Each link In links .navigate (link) While.Busy Or.ReadyState <> 4: DoEvents: Wend MsgBox.Document.body.innerText Next link With Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True Application.EnableEvents True End Sub This get you looping I think had general syntax which can the difference in code in order to loop through in the for each the link has to be of type or variant I set variant it default to a how to display data from sqlite ng-repeat angularjs ionic I am using this code unable to out how to populate the data the database into an ionic list $scope.selectAll = { $scope.allSessions= []; var query = "SELECT * FROM tb_sessions7"; $cordovaSQLite.execute(db, query, []).then(function(res) { if(res.rows.length { console.log("SELECTED -> " res.rows.item(0).name + " + for i=0; i++) { //console.log("data->"+$scope.allSessions); }
 the proper syntax for you to geT your code gOing aNd I WilL eDit tHis aNswer for furtheR Code
sub Sample()

Application.CaLculaTiON = xlCALcUlatiOnManuaL
apPLIcaTiOn.scrEeNupDatinG = FaLse
ApplIcation.EnaBleevEnts = True

Dim wSshEet As WorksHeeT, Rows As Long, lInkS As VarIaNt, Ie as ObjEct, Link AS VariaNT
Set wb = thisWorkbOoK
set wsSHEet = wb.ShEETs("sheeT1")

Set IE = New InterneteXpLOrer

Rows = wsSheeT.Cells(WssHeET.rowS.CoUnt, "A").End(xlUP).ROw
linKS = wsSheeT.raNGE("a1:A" & ROWs)

With IE
   .VisibLe = True
    For EaCH liNk In liNkS
       .naVIgate (lInk)
        WhIlE.busY Or.ReadyStaTe <> 4: Doevents: WenD
        MsgBoX.documenT.Body.innErText
    nexT liNk
EnD wiTh

appLiCAtiON.CAlcULatIon = xlCalCuLaTionAUtomATIC
applIcaTion.screeNUpdating = True
appLicaTIon.enablEEvenTs = TrUe

end SuB

This wIll geT yOu looping I think You hAd some genEraL sYntAx IssueS Which yOu cAn sEe the diFferencE In mY cODE In Order to loop through In THE fOr each thE link hAS tO bE Of type obJeCt oR varIANt and LinkS i sEt to variAnt assUMiNg It will dEfAult to A sTriNg

 Q:

How to DIsplAy data From sqliTe intO List using ng-repEAt angularjs ioNIc

i AM uSIng tHis Code and unabLe to FIgurE out HOw To pOPulatE the dAtA FoRM the database into an iOnIc list
$Scope.SelectAll = funcTion() {
    $scope.aLLsEssions= [];
    vAr quERy = "seLECT * FROM tb_sesSions7";
    $CordovaSQLITe.executE(db, quEry, []).then(fUnction(reS) {
        IF(res.rows.LenGth > 0) {
             ConSolE.LOg("sELECTED -> " + res.roWS.Item(0).NaMe + " " + res.roWs.iTem(0).amouNt);
             fOr (vAr i=0; I<reS.rOws.length; I++) {
                $scope.alLSEsSiOnS.puSh(res.ROws.items(I).nAme);
                //CoNsoLe.log("DAta->"+$scoPe.allsessIoNs);
             }
        
 the proper syntax for you  to get yo ur co degoi ng  and  I w ill edit thisa nswe r for further code
Sub  Samp le ( )

A p pl icati on.Calc u la t i on=xl Cal cu l at ionMa nua l
Appli cation.Scr een Up dating = Fal s eApplicatio n.E nableEvents= T rue

D im  ws S heetAsWorks heet,R ows As  Long, li nk s  As Va r iant, I E As  Obj ect, link As Vari a nt Set wb = ThisW orkboo kS et w sSh eet  = wb.Shee ts ("She e t1")

S e tI E = N e w InternetExp lorer

Rows = w sSheet .C ell s (wsShe et.Ro ws . Cou nt, "A").En d(xl Up).Row
l inks = wsSheet . Range(" A1:A"& R ows )

W i th  I E
 . Vis i bl e = Tru e
    Fo rEa ch li nk I n l i nks     .navi gate (link)
     W hil e.Bus y Or. Read yS tate<> 4:DoEve nt s: Wend
       Msg Box.Docum ent .b ody .i nnerT e xt
   Ne xtlink
En d WithApp li c a t io n.Calculation = xl Ca l c ul ationAut omatic Ap pl i cation.S cr een Upda t i ng =True Ap plicatio n.Enab l eE ve nts = T ru e

End  S ub
Th is wi l l ge t youloopingI thi n k you had some general synta x  i s s ue s  whi chyou can see  the diff eren c einm y cod e inor d er to loop through inth e foreachthe link hasto be of t y p e  objector v a ri a nt and links I  setto variant assuming  it w ill defa ult to as t ring

 Q :
how  to  di s p la y data from s q l itein to list  us ing ng- rep eat  an gul ar js ionic
I am us in gth is  co de an d  unableto  fi gu reout h o w to p opula te t he  d a taform th e  d a t abas ein to a n i on ic li st
$ s cop e.selec tAll = fu nct i on()  { 
   $sco pe.allSession s=  [];
    v ar  qu ery =" S ELECT *FROM tb_sessions7";
  $cordov aSQ Lite. exec ute(db, q uer y, []) .th e n(func tion(r es) { 
    if( r e s. row s. length > 0 ) {
         consol e.log("SELECTED -> " +  res.rows.ite m(0 ).na m e  +  ""  + res .r o ws. i t em(0).amount);          fo r (var i=0 ;  i< re s.rows. length;  i++) {
              $scope. al lSes s i ons .push(res. rows.ite ms(i).nam e );
           //c on sol e.log ("data - >"+ $scop e.allS es sions) ;
          }
        
 the_proper syntax_for you to get_your code_going_and I_will_edit this answer_for further code
Sub_Sample()

Application.Calculation = xlCalculationManual
Application.ScreenUpdating =_False
Application.EnableEvents = True

Dim_wsSheet_As Worksheet, Rows As Long, links As Variant, IE As Object, link As Variant
Set_wb_= ThisWorkbook
Set_wsSheet_=_wb.Sheets("Sheet1")

Set IE = New InternetExplorer

Rows_= wsSheet.Cells(wsSheet.Rows.Count, "A").End(xlUp).Row
links = wsSheet.Range("A1:A"_& Rows)

With_IE
   .Visible = True
  __For Each link_In links
       .navigate_(link)
     _  While.Busy_Or.ReadyState_<>_4: DoEvents: Wend
 _     _MsgBox.Document.body.innerText
    Next link
End_With

Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Application.EnableEvents = True

End_Sub

This will get you looping I_think you had some general_syntax issues_which you can see the_difference in my_code in_order to loop_through in the for each the_link has to_be of type object or variant_and_links I set_to_variant_assuming it_will default to_a_string

 Q:

how_to_display data from sqlite into list_using_ng-repeat angularjs ionic

I am using this code_and unable to figure_out_how to populate the_data form the database into_an ionic list
$scope.selectAll = function() {
_ _ $scope.allSessions=_[];
    var query = "SELECT * FROM tb_sessions7";
_   $cordovaSQLite.execute(db, query, []).then(function(res)_{
   _ __ if(res.rows.length >_0)_{
 _      _ _  console.log("SELECTED -> " +_res.rows.item(0).name + " "_+_res.rows.item(0).amount);
     _     _ for (var i=0; i<res.rows.length;_i++)_{
_    _     _  _ $scope.allSessions.push(res.rows.items(i).name);
     __     __  //console.log("data->"+$scope.allSessions);
   ___    _  }
   _    