Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 277 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Automation Excel Move Worksheet to the end
Reinder
Member Posts: 13
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
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
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
0
Comments
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.
It would be nicer if it worked directly from within Navision.
Did you create the macro in Navision?
Reinder
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
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.