Dyalog Forums

Function LoadXL from ws loaddata seems to get into a strange state under each.

      Dyalog APL/W Version 14.0.20815
Serial No : 501502
Unicode Edition
Beta release
Tue Apr 29 15:57:24 2014
clear ws
      )copy loaddata LoadXL
C:\Program Files\Dyalog\Dyalog APL 14.0 Unicode\ws\loaddata saved Mon Mar 31 17:18:14 2014
      ↑q←'C:\sv9\dictionaries\'∘,¨'Actives' 'Enhanced Deferreds' 'Enhanced Pensioners',¨⊂' Migration.xls'
C:\sv9\dictionaries\Actives Migration.xls            
C:\sv9\dictionaries\Enhanced Deferreds Migration.xls 
C:\sv9\dictionaries\Enhanced Pensioners Migration.xls
      ⍴r←LoadXL (1⊃q) 'Migration' ⍬
1020 16
      ⍴r←LoadXL (2⊃q) 'Migration' ⍬
396 16
      ⍴r←LoadXL (3⊃q) 'Migration' ⍬
147 16
      ⍴r←LoadXL¨{⍵'Migration'⍬}¨q
VALUE ERROR
LoadXL[24] :If 0≠XL.Workbooks.Count ⍝ Currently open books
                ∧
      book
C:\sv9\dictionaries\Enhanced Deferreds Migration.xls
      XL
#.[OLEClient]
      XL.Workbooks
VALUE ERROR
      XL.Workbooks
     ∧
      XL.MethodList

      XL.PropList
 Type  ClassName  Event  Data  Handle  ClassID  KeepOnClose  TypeList  HelpFile  LastError  Locale  AutoBrowse  QueueEven
      ts  InstanceMode  LateBind  MethodList  ChildList  EventList  PropList
      XL.Type
OLEClient

Observed in 14-beta, but I don't have here an earlier version with which to compare.

Okay, just needs a delay in the loop to allow the OLEClient to subside gracefully.