excel – Page 18 – Pardaan.com

Walkthrough: Using Automation to Create a Graph in Microsoft Excel

In this walkthrough, you will transfer data from the G/L Entry table to Microsoft Office Excel and create a graph. This example shows how to handle enumerations by creating a graph in Excel that shows the distribution of personnel expenses by departments. Bron : MSDN Lees…

6 November 2011

Dynamics NAV & BC Tips & tricks

Import from Excel

When starting a new company the needed data is in most cases accessible for Microsoft Excel. Do we want the user to be able to import data from Excel into Dynamics NAV ? Bron : Gunnar's Blog Lees meer...

1 November 2011

Dynamics NAV & BC Tips & tricks

NAV 2009 Tips and Tricks: Send lists and cards to Microsoft Word, Excel, and Outlook

It's easy to share Microsoft Dynamics NAV information with colleagues who do not have access to the application. You can export the information from Microsoft Dynamics NAV to Word, Excel, or Outlook, and share the document. Bron : Microsoft Dynamics NAV Team Blog Lees meer...

31 October 2011

Dynamics NAV & BC Tips & tricks

Start Excel from RTC

Starting the Excel application from the Role Tailored Client can result in an error if the Regional Settings do not match the installed language of Office. In my case, I have Dutch Regional Settings but Office is installed with English (United States). Bron : Microsoft Dynamics…

13 October 2011

Dynamics NAV & BC Tips & tricks

Export to Excel on Dynamics NAV: RTC

Due to many and frequent questions on the topic of performance when exporting to MS Excel on RTC, I've summarized some of the answers in this blog to try and explain the impact of running MS Office automation objects on RTC. Bron : Microsoft Dynamics NAV…

30 August 2011

Dynamics NAV & BC Tips & tricks

Make Exporting Excel Formulas Fully Multilanguage Aware

I have been struggling with exporting data from Dynamics NAV to Excel Spreadsheets including formulas lately. I had the problem with a custom developed export to excel so I checked the code in the Excel Buffer table to see how standard Navision solved the problem only…

20 July 2011