VBA Macro XML receiving Run-time error '91': Object variable or With block variable n
I was write code for Excel VBA XLM database values write into text file. when I using without any special characters XML values parsed into their text file without any issues but when I using special characters XML cannot parse special characters (&,- etc) error getting on my macro page. Anyone have any ideas on how to resolve this?
My code :-
Code:
Dim XDoc1 As Object
Dim XHTML1 As IHTMLElement
Dim XURL1 As String