Dll intialization issue?

(0) Share

Report

Posted on by Community Member

Hi,

i have below code

IF ISNULL(xlApp) THEN
xlApp := xlApp.ApplicationClass;
BEGIN
NoOfRows := CreateFile(VarAnalysisViewCodeLoc,VarShowBasicPeriod,
Rec_Prov,Rec, Sign, PeriodType-1, ShowName, GLAccFilter, Dim1Filter, Dim2Filter,
DateFilter, EmployeeFilter, ShowOnlyEmployees, AmountType);

and when i run this i got an below error.

Microsoft Dynamics NAV
---------------------------

Cannot create an instance of the following .NET Framework object: assembly Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c,
type Microsoft.Office.Interop.Excel.ApplicationClass.
---------------------------
OK
---------------------------

and my dll variable is

Name DataType Subtype Length
xlApp DotNet Microsoft.Office.Interop.Excel.ApplicationClass.'Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'

Can any one suggest me to achive this one.

Thanks in advance.

Ramesh

*This post is locked for comments

All responses (4)

Answers (0)

Corrado Lembo 15 on at

Like (0)

Report

RE: Dll intialization issue?

Problem is on code:

xlApp := xlApp.ApplicationClass;

RunOnClient Property is set to true.

Thanks
Suggested answer

RockwithNav 6,851 on at

Like (0)

Report

RE: Dll intialization issue?

Make Sure RunOnClient Property is set to true.

Which Line of code is giving this Error?
Corrado Lembo 15 on at

Like (0)

Report

RE: Dll intialization issue?

Do you have solved?

I've same issue but run on client not solve it.
Suggested answer

Suresh Kulla 47,789 on at

Like (1)

Report

RE: Dll intialization issue?

Set RunonClient property to yes for the variable and try.