Photo credit: baldiri

If you’ve ever copied and pasted a list of objects from Object Designer into Excel, you’ll know that the object types are represented in their numeric form, e.g., Table=1, Form=2 and so on.

I tend to keep a spreadsheet of objects associated with changes I make for customers and so hop into Excel quite frequently to paste in sets of objects.

To save myself the time of manually converting the integer values to their respective object descriptions, I used a VBA macro stored in the spreadsheet to do the job.

All well and good, but it just wasn’t funky enough!

So I hacked together a quick Add-In for Excel 2007 to do the same job.

The advantage of using an Add-In is that it is easily distributable and can be given its own tab and button on the Excel Ribbon.

Once the add-in has been enabled in Excel, clicking the Convert Object Types button will do the conversion and make the Type column nice and readable.

I do have some other VBA bits and pieces lying around for manipulating Object Desinger data which I will probably include in this Add-In at a future date, as the single button does look a bit lonely

Download

If you’d like to try it for yourself you can grab the Add-In using the link below.

All you need to do is save the file to a suitable location and enable it as an Add-In from Excel Options.

Let me know in the comments if you find it useful.

Download the Dynamics NAV Excel Add-In

NOTE: Rename dynamics-nav-add-in.zip to dynamics-nav-add-in.xlm