Subscribe via RSS Feed Connect on LinkedIn

Tag: Excell Buffer

Excel Multiple Worksheets in Dynamics NAV

20th June 2015 2 Comments
Excel Multiple Worksheets in Dynamics NAV

There are a few solutions for adding Multiple Worksheets to an Excel Workbook for earlier versions of Dynamics NAV, many of these solutions are not transferable into Dynamics NAV version 2013, I thought I would add my solution for Dynamics NAV 2013 R2, in Part One I will show the changes to the Excel Buffer, […]

Please Share this Post:

Continue Reading »

Excel Multiple Worksheets Report

20th June 2015 0 Comments
Excel Multiple Worksheets Report

In this post I will show the code added in a Report to use the multiple Excel Worksheets in Dynamics NAV 2013, in Part One I looked the changes to the Excel Buffer, and in Part Three I will add functions for formatting and to create real formulas. The Report 50004 Export Items by Inventory […]

Please Share this Post:

Continue Reading »

Excel Multiple Worksheets Report Extended

20th June 2015 0 Comments
Excel Multiple Worksheets Report Extended

In this Final Part I will add functions for formatting and to create real formulas in Excel with Dynamics NAV 2013 R2, in Part One I looked at the changes to the Excel Buffer, in Part Two I explored the code added in a new report to use the multiple Excel Worksheets. The Report 50006 […]

Please Share this Post:

Continue Reading »

Dynamics NAV 2013R2 Excel Buffer Part 1

18th October 2014 0 Comments
Dynamics NAV 2013R2 Excel Buffer Part 1

Table 370 Excel Buffer This post is the first in a series of three on using the Microsoft Dynamics NAV Excel Buffer, the Excel Buffer in Dynamics NAV is little used in the Standard Object range, if we search for an example to import cells from Excel into a table we only have a few […]

Please Share this Post:

Continue Reading »

Dynamics NAV 2013R2 Excel Buffer Part 2

18th October 2014 0 Comments
Dynamics NAV 2013R2 Excel Buffer Part 2

This Post is the second in a series of three on using the Microsoft Dynamics NAV Excel Buffer, if you have not read part one you can Read it Here, in this post I will look at creating a Report that I can use as a Template to enable me to import data from an […]

Please Share this Post:

Continue Reading »

Dynamics NAV 2013R2 Excel Buffer Part 3

18th October 2014 0 Comments
Dynamics NAV 2013R2 Excel Buffer Part 3

This post is the last in a series of three on using the Microsoft Dynamics NAV Excel Buffer, if you have not read part one you can Read it Here, if you have not read part two you can Read it Here, in this post I will use the Template Report I created in part […]

Please Share this Post:

Continue Reading »