Excel Automation and the Copy-Method

DirkSimon

Hi,

i want to Copy an Excel Worksheet after the current Worksheet

The parameters are:

[lDISPATCH Add:=]Add [VARIANT Before][,VARIANT After][,VARIANT Count][,VARIANT Type]

In Visual Basic it works with following code

cexcel.Worksheets("Tabelle1").Copy after:=cexcel.Worksheets("Tabelle3")

but not in Navision Attain. Does anybody have an idea?

Regards

Dirk

tvandongen

We have had a similar problem and find a solution in adding a macro which do the trick and start the macro from navision (worked with 2.60A).

DirkSimon

Thanks!

That was a good idea.