I have now seen three posts about using Excel to help create a Pipe Filter. The latest one from Mohana is similar to the way I normally do this. His post is a followup from the original video from Kerry Rosvold and an alternative from Mark Brummel.
If this is something you frequently need to do, why don’t use NAV and skip the Excel part ?
Lets imagine how that could look like.
We add a button the ribbon, select what ever we like from the customer list and click the button.
Now it just a matter of using the filter. Paste it where ever you need it.
And this is with just a few lines of code.