Thanks again Graham.
"turn off confirm file format conversion on open" - is that for Word or Excel ? Or both ? I found it in Word (it wasn't checked) but, oddly, that option is not visible in Excel 365 in Options>Advanced>General (or anywhere else as far as I can see).
Also in Excel, "Ignore other application that use DDE" is NOT checked.
I had a look at OLE DB but couldn't understand which of the many options to choose, and what to enter when it says "Data source". I tried the file path (with and without quotes) to no avail.
|