I am using export xml function in order to export some data from an excel file. The problem is that for multiple elements export xml function is outputting empty xml tags when no value is present for an element (<element1></element1>). I need to remove these empty tags somehow.
I found a method on a forum that use regex function that accomplish this task.
Please Login or Register  to view this content.
I don't manage to adapt this code in vba in order to accomplish the same task.
Thank anyone who can help with an ideea.