Automation Excel Move Worksheet to the end

Reinder

I'm trying to move a worksheet in Excel to the end but get error message in Navision Financials: "Call to member Move failed"

In Visual Basic it looks like: Sheets("Name").Move After:=Sheets(2)"

Can anybody help me with the syntax in Navision.

Thanks,

Reinder

tvandongen

Reinder,

I had similar problems just by switching between sheets. We solved it by making a macro which do the actually switching and just activate the macro from navision.

Maybe you can do it for your excell sheet as well.

Reinder

tvandongen,

It would be nicer if it worked directly from within Navision.
Did you create the macro in Navision?

Reinder

tvandongen

Reinder,

No I have created the macro in excell. I agree with you that running it in Navision is nicer, but because the starting of the macro takes place from navision, the user don't see that a macro is started to do the job.