NeedForExcel, both codes bellow works. 2. code is more complex.
1. jakopak
MyString = "<?xml version = ""1.0"" encoding = ""UTF-8""?>"
2.NeedForExcel
MyString = """<?xml version = """ & "1.0" & """ encoding = """ & "UTF-8""" & "?>"""
What I hope for is something like bellow. Using tag to wrap a string, so there is no need to add quotes in the middle of a string.
MyString = <tag1><?xml version = "1.0" encoding = "UTF-8"?><tag1>
The problem with the code 1. and 2. is, that if I write the string into file.xml, then the string is written exactly with added quotes. With added quotes the xml file is not working.
EDIT:
Solution
command print prints string without added quotes.
Bookmarks