Browse by Tags

Tagged Content List
  • Blog Post: Edit In Excel R2 – Part 2 (out of 2) – the final pieces

    It is time to collect the pieces. The full Edit In Excel R2 solution looks like this Slightly more complicated than the first version – but let me try to explain the pieces NAVEditInExcel is the COM object, which we use from within NAV. This actually hasn’t changed a lot, the only small change is, that...
  • Blog Post: Dynamic references to NAV Page Web Services in C# – take 2

    In this post from April, I explained how to make dynamic references to page based Web Services, but the post really left the developer with a lot of manual work to do using reflection. So – I thought – why not create a couple of helper classes which makes it easier. Basically I have created a generic...
  • Blog Post: Dynamic references to NAV Page Web Services in C#

    Note: There is an updated post about Dynamic references to NAV Page Web Services here . When creating the very first (never published) version of Edit In Excel, it was loosely coupled, meaning that I did not have any Web references in the project to the Customer Page, Vendor Page or other pages. I read...
  • Blog Post: Edit In Excel R2 – Part 1 (out of 2)

    This post assumes that you have read the 4 step walkthrough of how to build the Edit In Excel demo from November 2008. You can find the parts here: Part 1 , Part 2 , Part 3 , Part 4 and the Bug Fix . In this post I will talk about what is needed in order to be able to save an Excel spreadsheet on a local...
  • Blog Post: Edit In Excel – bug fix and R2

    If you haven’t read the 4 step walkthrough of how to Edit In Excel from Microsoft Dynamics NAV, you should do so here this post is a follow up to the original posts. I have received a number of suggestions to what you could do with the Edit In Excel and a single bug. In this post I will fix the bug and...
  • Blog Post: Edit In Excel - Part 4 (out of 4)

    If you haven't read part 3 , part 2 (and part 1 ), you should do so before continuing here. We have seen how to put code inside Excel, using VSTO and connect to NAV 2009 Web Services. We have seen how to add this to a table inside Excel and how to write data back to NAV through Web Services. We can delete...
  • Blog Post: Edit In Excel - Part 3 (out of 4)

    If you haven't read part 2 (and part 1 ), you should do so before continuing here. In Part 1 and 2, we have seen how easy it is to add a Web Service Reference inside Excel, and use it to get Data. In Part 2 we even had the ability to modify data and send this back to NAV. The original intend was that...
  • Blog Post: Edit In Excel - Part 2 (out of 4)

    If you haven't read Part 1 , you should do so before continuing here. In Part 1 we saw how easy it is to white .net code inside Excel, and get it executed based on an event in Excel, and how easy it is to fill values into cells. But in order to make this really useful we need to go a different way around...
  • Blog Post: Edit In Excel - Part 1 (out of 4)

    For the last 6-9 months, Microsoft have been showing a demo of how a user could create a filter on a list place and invoke an action called Edit In Excel. This would open Microsoft Excel with the same records, the user selected in the List Place and allow the user to edit values and post modifications...
Page 1 of 1 (9 items)