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
- 305 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 Excel export with NAS
Emerik
Member Posts: 50
Hello,
I have written a report, that uses the Table 370 Excel buffer to export data to multiple Excel-files. It works fine, when I run the report manually (with same user as with NAS), but when I let the NAS run it, it fails during the first export with the following error:
Runtime is NAV 5.0 SP1
Database is NAV 4.0 SP1
OS is Windows Server 2008 Standard SP1
Excel is MS Office Excel 2007 SP2
NAS is NAV 5.0 SP1
Can anyone figure out, what could be wrong?
P.S. I have just tried to run the NAS with the debug option. It seems to work ALSO. Weird... Why would it work in debug mode and not in normal mode?
Kind regards,
Emerik
I have written a report, that uses the Table 370 Excel buffer to export data to multiple Excel-files. It works fine, when I run the report manually (with same user as with NAS), but when I let the NAS run it, it fails during the first export with the following error:
This message is for C/AL programmers: An exception was raised in method SaveAs. The OLE control or Automation server has returned error (HRESULT) -2147352567. The component did not provide the exception description.
Runtime is NAV 5.0 SP1
Database is NAV 4.0 SP1
OS is Windows Server 2008 Standard SP1
Excel is MS Office Excel 2007 SP2
NAS is NAV 5.0 SP1
Can anyone figure out, what could be wrong?
P.S. I have just tried to run the NAS with the debug option. It seems to work ALSO. Weird... Why would it work in debug mode and not in normal mode?
Kind regards,
Emerik
0
Comments
viewtopic.php?f=23&t=38483
This guy solved his issue though
viewtopic.php?f=23&t=26971&hilit=excel+NAS&start=15
Thank you for your reply. However, my problem is slightly different, and cannot be resolved by the thread mentioned.
The errors are different. And I have noticed, that in debug mode, the export with NAS works just fine, whereas it doesn't work, when NAS is not in debug mode.
NAS user is member of the servers Administrators group.
So I would still like to get some help on this issue.
Thx anyway.
Emerik
I've an analog problem in reading excel by NAS.
I'm thinking there is something in excel 2007 running in background.
I've tried to insert a XlApp.VISIBLE:=FALSE , but nothing changed.
Were you ever able to resolve this issue? I am experiencing exactly the same problem and cannot find a resolution anywhere.
Thanks,
Greg.
This solution is ...
・Windows 2008 Server x64
Please make this folder.
C:\Windows\SysWOW64\config\systemprofile\Desktop
・Windows 2008 Server x86
Please make this folder.
C:\Windows\System32\config\systemprofile\Desktop
p.gruetter(at)darkmaster.ch
4402 Frenkendorf
www.pascal-gruetter.com
www.darkmaster.ch
I love mibuso - it has got me out of so many holes. and darkmaster can chalk up another one!
Thank you.