Share
ReportHi Experts,
1. I need to update excel data from NAV
2. After updating excel data, I need to import excel data into NAV.
Both processes using same file.
For that I written If updateExceldata then
ImportExceldata;
I updated excel data from NAV as suggested Robert in the following Post
https://community.dynamics.com/nav/f/34/t/193287
It's working Fine.
After updating data Importexceldata will run
In this case Amount Values didn't import (Remaining Values inserted).
In Excel sheet Amount values are calculated by formulas.
If I run updatexceldata first (in this case i commented //ImportExceldata;)
After updating, manually opened file and saved.
Then I run ImportExceldata (in this case i commented //updatexceldata;)
in this case data inserted perfectly.
I got problem when i run both processes at a time.
What i am thought after updating data i need to save the file then only import data works fine.
So I need how to save excel file after updating data (Before import).
I can't use any XlApp,XlWrkBk,XlWrkSht,XlHelper variables these are not working through NAS.
I need this process through NAS.
I can use ExcelBuffer standard procedures.
So Please suggest me how to achieve this.
Thank you.
*This post is locked for comments
All responses (
Answers (
291,280
