Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 309 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Problem with export to Excel
rtom
Member Posts: 4
Hi,
I have one more problem with the export to Excel from Navision 3.60. Sometimes when I run the export to Excel from GL, Anaysis by dimensions, I get the error message stating that the automation variable is not instantiated and the system stops. Next time it runs perfectly without a problem. I tried to check the codeunit 424 with the debugger, but everything seemes OK. The Custom controls have the necessary Office controls registered, so there should be no problem.
Pls. let me know if anyone knows how to solve this.
Thanx.
I have one more problem with the export to Excel from Navision 3.60. Sometimes when I run the export to Excel from GL, Anaysis by dimensions, I get the error message stating that the automation variable is not instantiated and the system stops. Next time it runs perfectly without a problem. I tried to check the codeunit 424 with the debugger, but everything seemes OK. The Custom controls have the necessary Office controls registered, so there should be no problem.
Pls. let me know if anyone knows how to solve this.
Thanx.
0
Comments
It could be the excell component hasn't been cleared or closed after use. Or maybe due to an error this component can't be closed.
The way to check this could be running the report (or what ever you run to get the stuff in excell) and open the taskmanager (Ctrl+Alt+Del).
Goto processes and search for the process EXCEL.EXE, if it's there and either you don't have an excell sheet open or you already closed it, something is wrong and this process must be stoped.
If it was hard to write, it should be hard to understand."