Looking to Remove Namespace Declaration

[Derek1985]

I am setting up an Export macro for my friends brewery controller and the following:

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance

needs to be removed in order for the outputted XML file to be input into his equipment with no errors. We’ve tried a few times and done a line by line troubleshoot of the file and it’s definitely this statement.

Is there a simple way to remove it in my VBA code for the spreadsheet?

 

[Rijnsent]

I don't know how you export that XML file, but in that same macro you could include code like this: FreeVBCode code snippet: Delete a Specified Line from a Text File
Hope that helps, otherwise please share a bit more of your current code/setup.
Koen