vba error for writeline

[nilambari28]

I am getting error while using writeline() when it was writing text with special character ≠

text = if Q1 ≠ NO

So please help me to handle this error and write this content in new file

[AliGW]

You have marked this as solved - is it?

In Excel, the 'not equal' symbol is usually <>.

[nilambari28]

Actually there is text "if Q1 ≠ NO" in excel file and when i am using writeline() function to write this text to new file, it is throwing error.

[AliGW]

OK - You need to remove the solved tag from your thread, then. Sorry - I can't help myself with your query.

[TMS]

You need to share the Excel file AND your code so we're not all starting from scratch.

[Haluk]

@nilambari28 ;

If range A1 is housing the text "if Q1 ≠ NO" then, try the following code in which WriteLine method is used.

The magic is the last "True" parameter in the "CreateTextFile" function, which forces the "textStream" object to create the text file as a unicode file.

Please Login or Register  to view this content.