-
Hi, Is there a way to fix the width of the cell in excel? Scenario: 1. I create a report that get the template in Excel file. 2. Use the template to populate the data base on the excel template. 3. But when send all the data to excel it, ruined the template because the cell is expanding, so I want to...
-
Hi, I am getting error from Table 370 Excel Buffer on function 'CreateSheet(SheetName,ReportHeader,CompanyName,UserID2)' and in the line IF Formula = '' THEN XlWrkSht.Range(xlColID + xlRowID).Value := "Cell Value as Text" Please help ...How can i solve this????? Regards Rose
-
Dear all I am geting one Error when i create Excel Sheet. The error is " An Exception was raised in method range.The OLE control of automation server has returned error(HRESULT)-2147352567.The component did not provide Exception description." Whats the problem with it..??why its coming??how...
-
Hi to all members. again i am infront of you with a small problem. i saw that there is a syntax for "find" in navision as given below: [range find:=]find(variant what[,variant after][,variant looking][,variant lookat] [,variant searchorder][,xlsearchdeirection searchdeirection][,variant matchcase...
-
Hi All, I find it very useful to copy data from tables out of Navision and paste the data into excel, however on occasions the data will paste into the fist cell in each row of excel, instead of a new cell for each field. Generally after a few hours the problem resolves itself but seems to reoccur on...
-
Hi Greg, Depending on the report and the complexity there are a number of options: 1. No codeing bt messy output - In the preview window of the report select File -> Save as HTML. Then open the HTML file in Excel 2. The way most report are coded - Nav use a table 370 Excel Buffer for Excel input/output...
-
Hi, We're running NAV 5.0 SP1. I'm new to this forum, so please don't shoot me, if this question is too easy or filed in the wrong section. I want to open an Excel file by clicking on an item in the navigation panel in NAV. I don't need data to be exported or linked. I just need to access...
-
Hi all We have a problem on some computers when exporting a sales quotation to Word or Excel. I cannot find any information regarding this scenario and the Event Log does not have a description for the error. The log entry is as follows: Event Type: Error Event Source: Microsoft Dynamics NAV Event Category...
-
Hi Kamel, Andrew is correct - the standard way to export to Excel from Nav is to use the Excel Buffer table (table 370) and functions. For your situation you can set the last argument on the AddColumn function to '@' to format as a string i.e. assigning the numberformat field. Look at the export...
-
The problem is that a dataport simply generates a TXT file, you simply are using excel to open it as a CSV file. If you export it as a TXT file, then when you open it in EXCEL you will get the Text file wizard which will enable you to define the field properties. The other option is to open it within...