You’re offline. This is a read only version of the page.
422
Hi,
I have created a automation variable ('Microsoft Excel 14.0 Object Library'.Application) in NAV 2013 R2 report. I am trying to export datas' to excel. When I compile, its okay. But, when I try to save the report, it shows below message:
'You cannot create an Automation object "XLApp22" on Microsoft Dynamics NAV Server. You must create it on a client computer'
where XLApp22 is the automation variable.
,Abdul
*This post is locked for comments
Okay, I am going through excel buffer table for the dotnet variable. thank you.
,Abdul
about the same error, please check whether you have CREATE statements in multiple places.
you have to check in excel buffer table for DotNet variable and example.
that is what I meant in previous post.
Hi Mohana, this is needed to be updated in the jobs, to save the files, excel buffer wont help this right?.
Now I written CREATE(XLApp22,FALSE,TRUE) in my code and complied it, still its showing same message while saving.
And, how it can be done using DotNet variable?, which assembly and codes' I should use ?.
,Abdul.
And why are you using Automation variable.
you can use DotNet variable.
Please check table 370 excel buffer
It seems like you have used CREATE(XLApp22) in your code
Please use CREATE(XLApp22,FALSE,TRUE)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (