Automation Excel Move Worksheet to the end

Reinder
Reinder Member Posts: 13
edited 2003-09-19 in Navision Financials
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
Reinder van der Veen

Reinder ICT Nijmegen
Wolfskuilseweg 96 - 6542 JM NIJMEGEN - The Netherlands
Tel.: +31 (0) 24 373 81 38 - Mob.: +31 (0) 6 20 650 311
E-mail: reindervdv@gmail.com

Comments

  • tvandongen
    tvandongen Member Posts: 78
    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
    Reinder Member Posts: 13
    tvandongen,

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

    Reinder
    Reinder van der Veen

    Reinder ICT Nijmegen
    Wolfskuilseweg 96 - 6542 JM NIJMEGEN - The Netherlands
    Tel.: +31 (0) 24 373 81 38 - Mob.: +31 (0) 6 20 650 311
    E-mail: reindervdv@gmail.com
  • tvandongen
    tvandongen Member Posts: 78
    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.

Categories