Passage paramétres Ole Excel

[Tranber44]

Hello,
It is not for lack of having tried very numerous solutions but I did not find the way of crossing the parameters special collage under OLE Excel. Thank you for your help.

x←WAdh.Sheets.(Item('xxxxxxxxxxx')).(Range('A20:R31')).PasteSpecial('Paste:=xlPasteAll')
DOMAIN ERROR

Regards

Bertrand Delassus

[Morten|Dyalog]

Bertrand,

New syntax was introduced in Version 11.0 of Dyalog APL, controlled by the value of the system variable ⎕WX (http://help.dyalog.com/13.2/Content/Language/System%20Functions/wx.htm).

The default in a new version of APL is ⎕WX=3. Can you try the following and see if it works?

Code: Select all

x←WAdh.Sheets[⊂'xxxxxxxxxxx'].Range[⊂'A20:R31'].PasteSpecial ⊂'Paste:=xlPasteAll'


You can revert to the old behaviour by setting ⎕WX to 0 or 1, but I think it is a better idea to adapt your code to the improved syntax.