Passing Parameters to Excel.

[byron.hopp]

All,

I am puzzeled on how to use some of the methods in Excel, because the parameter passing is unusual.

Dim sheet As Worksheet
Set sheet = ActiveWorkbook.Sheets.Add(After:=ActiveWorkbook.Worksheets(ActiveWorkbook.Worksheets.Count))

Is there a way to make this work in Harbour / Fivewin?

Thanks,

Byron ...

[anserkk]

Dim sheet As Worksheet
Set sheet = ActiveWorkbook.Sheets.Add(After:=ActiveWorkbook.Worksheets(ActiveWorkbook.Worksheets.Count))

Try

Code: Select all

oSheet := oExcel:ActiveWorkbook:Sheets:Add( oExcel:ActiveWorkbook:Worksheets( oExcel:ActiveWorkbook:Worksheets:Count() ) )

[byron.hopp]

Thank you, if that is "After" then how would you do before?