Syntax for multiple parameters in object calls

[randallc]

hi,

As this was not working when I wrote the ExcelCOM UDF, I used scripting object and vbscript.

There was a note that it had been fixed, but I cannot find syntax that works, as empty parameters are apparently NOT accepted.

Can this be fixed, or is there alternative syntax in AutoIt syntax?

Thanks, Randallc

1. Sort (examples with xls in zip)

2. Import.

3. Charts.

etc

[randallc]

eg; in above zipped examples

>Running:(3.1.1.127):C:\Program Files\AutoIt3\beta\autoit3.exe "C:\Programs\SearchEngine\XLSort2.au3"    
C:\Programs\SearchEngine\XLSort2.au3 (18) : ==> The requested action with this object has failed.: 
.Application.Selection.Sort ($objrange1, $i_Direction1,$objRange2,False,$i_Direction2,False,False,False,2, False,1) 
.Application.Selection.Sort ($objrange1, $i_Direction1,$objRange2,False,$i_Direction2,False,False,False,2, False,1)^ ERROR
+>AutoIT3.exe ended.rc:0
>Exit code: 0    Time: 2.360
oÝ÷ Ù©Ýjëh×6.Application.Selection.Sort ($objrange1, $i_Direction1,$objRange2,,$i_Direction2,,,0,2, ,1)

gives syntax error at the empty parameters.

Thanks, Randall

[DaleHohm]

Try:

.Application.Selection.Sort ($objrange1, $i_Direction1,$objRange2,Default,$i_Direction2,Default,Default,0,2,Default,1)

[randallc]

Hi,

No luck here; did you try it?

>Running:(3.1.1.127):C:\Program Files\AutoIt3\beta\autoit3.exe "C:\Programs\SearchEngine\XLSort2.au3"    
C:\Programs\SearchEngine\XLSort2.au3 (19) : ==> The requested action with this object has failed.: 
.Application.Selection.Sort ($objrange1, $i_Direction1,$objRange2,Default,$i_Direction2,Default,Default,0,2, Default,1) 
.Application.Selection.Sort ($objrange1, $i_Direction1,$objRange2,Default,$i_Direction2,Default,Default,0,2, Default,1)^ ERROR
+>AutoIT3.exe ended.rc:0
>Exit code: 0    Time: 2.440

Best, Randallc

PS - Is there any documentation of this which I am not seeing in the Help File?

PPS - vbs works with; [as in zipped vbs]

.Application.Selection.Sort objrange1, Direction1,objRange2,,Direction2,,,0,2, False,1

Edited June 29, 2006 by randallc

[DaleHohm]

Hi,

No luck here; did you try it?

No, but this was added in beta 60 for COM functions... see the changelog:

Added : Usage of 'Default' keyword instead of empty arguments to COM functions (only valid if COM function supports it). (By SvenP)

Dale

[randallc]

Perhaps "not supported";

I was about to do the "Import" to Excel as scripting object, but hoping to use autoIt instad...

Oh well..

Randallc

[SvenP]

Perhaps "not supported";

I was about to do the "Import" to Excel as scripting object, but hoping to use autoIt instad...

Oh well..

Randallc

Hello Randallc,

The problem is not in the 'Default' argument, but it's about the Order3 argument in de Sort method. Somehow this argument does not seem to be optional in other languages.

It is a known issue, see a previous bug report: http://www.autoitscript.com/forum/index.php?showtopic=16157

(Hmm, seemed to be submitted by yourself a year ago?)

Your script will work when you replace the Order3 argument with the value 1:

.Application.Selection.Sort ($objrange1, $i_Direction1,$objRange2,Default,$i_Direction2,Default,1,Default,2, False,1)

Regards,

-Sven