Hi group,

I'm using PHP5 to program Excel vie COM interface and have run into a snag
( for me anyway ). I am trying to use the .Add method on a Worksheet and
can't figure out the following:

From microsoft: (optional are 'Before, After, Count, Type)
ActiveWorkbook.Sheets.Add Befo=Worksheets(Worksheets.Count)


turns into PHP:
$this-excel-Worksheets-Add()

except I don't know how to specify 'Before, After, Count, Type' as options.?
It will accept one 'sheet obj' as an argument such as:

$this-excel-Worksheets-Add($this-excel-Worksheets(2))
but how do I specify if it's 'Before' or 'After' as well as 'Count' and
'Type'?

This doesn't work for me: (pseudo VB style)
$this-excel-Worksheets-Add(Befo=??, After:=??, Count:=??,
Type:=xlWorksheet)

Can anyone point me in the right direction?

Thanks,
Norman



--
Avatar hosting at www.easyavatar.com