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.
I don't manage to adapt this code in vba in order to accomplish the same task.Please Login or Register to view this content.
Thank anyone who can help with an ideea.
Bookmarks