How ommit a parameter in a COM Method?

[GioVit]

I'm working with excel COM object and I need to Skip (ommit) a parameter in a Function that add a new Worksheet. The parameters of the funtion are:

Function Add([Before], [After], [Count], [Type]) As Object

so if I want to Add a worksheet after the $o_worksheet object, in the $o_workbook object I need to set the parameters this way

$o_newWorksheet = $o_workbook.Worksheets.Add([ommited param], $o_worksheet)

But this si not allowed in Autoit and I cant find a value that emulate a null parameter.

BTW if I Set both Parameters [before] and [After] I get an Error

Any suggestion?

Thanks in advance

[Uten]

Is the Add function a AutoIt function? Or is it a method on a object you have created earlier?

The function declaration and the sample does not seem to match at all in my eyes. But I don't know mutch about com in AutoIt

[DaleHohm]

Is the Add function a AutoIt function? Or is it a method on a object you have created earlier?

The function declaration and the sample does not seem to match at all in my eyes. But I don't know mutch about com in AutoIt

Have you tried "" (that two if these: ") ?

Dale

Edit: typo

Edited June 10, 2006 by DaleHohm

[GioVit]

Have you tried "" (that two if these: ") ?

Dale

Edit: typo

Yes I Tried with "" and get an error and it is an object method, Uten

but I solved it by "moving" the sheet before the next 2 sheet

Thanks DaleHohm and Uten

but I think AutoIt should offer a way to skip parameters

[Uten]

Dont you have to use another calling convention if you want to skip parameters?

In an excel script you would do something like this (If I recall right):

objX = object.Add("After:= 1, Type:=" & struct.something)

Edited June 10, 2006 by Uten

[GioVit]

Dont you have to use another calling convention if you want to skip parameters?

In an excel script you would do something like this (If I recall right):

objX = object.Add("After:= 1, Type:=" & struct.something)

Yes I tried it too but is not allowed in AutoIt or if so, I don't know how to apply

[GioVit]

I mean if I write

$o_worksheet = $o_worbook.Workbooks.Add('After := "Sheet1"')

I'll get a COM Error

[Uten]

Leaves me all out of ides

Sorry.

[GioVit]

Leaves me all out of ides

Sorry.

it's Ok many thanks anyway

[DaleHohm]

I mean if I write

$o_worksheet = $o_worbook.Workbooks.Add('After := "Sheet1"')
oÝ÷ ØýXµ 0J뢿êº^¬¶¬³)ík(®F®¶­s`¢b33c¶õ÷v÷&·6VWBÒb33c¶õõÂåv÷&¶&öö·2äFBgV÷C´gFW#£Õ6VWCgV÷C²

This assumes that $o_XL is your Excel.Application automation object. This is the syntax I would assume after looking at the object docs.

Dale

ps. also consider adding a COM error handler to get more specifics about the error.

[Valik]

The Default keyword is used to skip parameters in COM calls:

$o_newWorksheet = $o_workbook.Worksheets.Add(Default, $o_worksheet)

Edited June 10, 2006 by Valik

[GioVit]

@DaleHohm, @Valik

none of both suggestion work.

I'm trying to program a new ExcelUDF, here are the source code it is incomplete but what I'm testing until now is working, if you want to try it here is the source code, install both files in the same directory.

The error in question is in line # 261 of ExcelUDF.au3 and if you want to find some solution you must coment lines 262, 263, 264.

Thank you

ExcelUDF_Test.au3

ExcelUDF.au3

[DaleHohm]

@DaleHohm, @Valik

none of both suggestion work.

I'm trying to program a new ExcelUDF, here are the source code it is incomplete but what I'm testing until now is working, if you want to try it here is the source code, install both files in the same directory.

The error in question is in line # 261 of ExcelUDF.au3 and if you want to find some solution you must coment lines 262, 263, 264.

Thank you

Have you tried the command in VBScript? Show a small working example in VBScript and we'll have more to work with.

Dale

[GioVit]

Have you tried the command in VBScript? Show a small working example in VBScript and we'll have more to work with.

Dale

in VBScript work with this format

Worksheets.Add  After:=Sheets(1)

but I don't know how to apply this kind of parameter assignment into Autoit ("After:=Sheet(1)")

[DaleHohm]

in VBScript work with this format

Worksheets.Add  After:=Sheets(1)

but I don't know how to apply this kind of parameter assignment into Autoit ("After:=Sheet(1)")

That's just one line of code. If you'll provide a small stand-alone example in VBScript I'm willing to experiment and try to help.

Dale

[GioVit]

That's just one line of code. If you'll provide a small stand-alone example in VBScript I'm willing to experiment and try to help.

Dale

Sub Macro1()
'
' Macro1 Macro
' Macro grabada el 11/06/2006 por GioVit
'

'
    Sheets("Sheet1").Select
    Sheets.Add After:=Sheets(1)
    Sheets.Add After:=Sheets("Sheet3")
End Sub

After and Before Parameters are of type Worksheet

This is VBA Code Inside an Excel Macro and I don't know if it differ with code in VBScript, because I have never used VBScript

[RicFrancescoGeraci]

This is an exert from autoit documentation.

To skip an optional parameter, leaving its default value intact, use:
    "" for string parameters
    -1 for numeric parameters

 

[water]

Welcome to AutoIt and the forum!

You have noticed that the thread is nearly 8 years old and the OP has been offline for 3 1/2 years?

Please don't necro old threads