Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Plug Existing Excel Cell with Table info
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00680666
Message ID:
00682305
Views:
12
>Any ideas why an error limit of 6875...
>
>
>oExcel=CREATEOBJECT("Excel.Application")
>nARow= 2
>cRange= "A"+ AllTrim(Str(nARow))
>Use "Z:\ARMN\DATA\XTESTS" Alias X12 in 0 Shared
>Select X12
>With oExcel
>  .WorkBooks.Open(cMainTemp)
>  .ActiveWorkBook.SaveAs(cToSaveAs)
>  .DisplayAlerts= .F.
>  Scan
>   .Sheets("Testing").Select()
>   nMaxRows= .ActiveWorkBook.ActiveSheet.Rows.Count
>   Do While nARow < nMaxRows
>      Wait Window NoWait AllTrim(Str(nARow))
>      nARow= nARow+ 1
>      cRange= "A"+ AllTrim(Str(nARow))
>      .Range(cRange).Select()
>      If AllTrim(.Range(cRange).Value)= AllTrim(X12.Submitter)
>         cRanges= "B"+AllTrim(Str(nARow))
>         cRanget= "C"+AllTrim(Str(nARow))
>         cRangep= "H"+AllTrim(Str(nARow))
>*** I get an error on the next line
>**** Subscript Out of Range (6875) (maxrows= 65536)
>         .Range(cRanges).Value= AllTrim(X12.Schddate)
>         .Range(cRanget).Value= AllTrim(X12.TestDate)
>         .Range(cRangep).Value= AllTrim(X12.Passeddate)
>      EndIf
>   EndDo
>   .Sheets("Arkansas Enrollment").Select()
>...
>
>Thanx
Edgar L. Bolton, B.S. B.B.A.
Previous
Reply
Map
View

Click here to load this message in the networking platform