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…

19

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…

0

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…

0

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…

6

Transferring binary data to/from WebServices (and to/from COM (Automation) objects)

A number of people have asked for guidance on how to transfer data to/from COM and WebServices in NAV 2009. In the following I will go through how to get and set a picture on an item in NAV through a Web Service Connection. During this scenario we will run into a number of obstacles…

25