I have foreign (non-English) characters in a cell in Excel which I was reading using Sheets("data").Cells(1,1).Formula
However this returned nothing but questions marks instead of the text:e.g. ζχψωβνιθςεβφ[ςε turns into "????ί????eίf[?e"
After research I discovered I needed to set the regional settings to the foreign country and needed to use FormulaLocal: Sheets("data").Cells(1,1).FormulaLocal
Now however I'm only getting some of the foreign characters - others are appearing as question marks. e.g "?χψω???εβφ?e"
Any idea how to proceed? Thanks.