vba code for excel - to encoding gibrish to hebrew

Question

i have files that open with excel. when i open the file the text is like gibrish. i need to encode - tools-internet option - general-encode - hebrew iso-visual and then the file turn to hebrew

there is a vba code that do that ?

thanks, omri

Answer 1

I don't really have a way to test this, so I am just taking a shot:

Excel.ActiveWorkbook.WebOptions.Encoding = msoEncodingHebrew