Microsoft is not my friend today

[SandyDoss]

Does anyone know a way to force Excel 2016 to open an earlier versioned workbook (.xls) NOT in read only mode??
I don't believe I want the user to change their 'trusted' settings or 'protected' settings. I'm using the workbook only as a temporary place to store data during a macro run.

Alternatively, I'm under the impression that MacroScheduler doesn't support opening a workbook with the extension .xlsx. True?

Thanks - Sandy

[Marcus Tettmar]

XLOpen can indeed open an xlsx file. It is simply passing the request to Excel via ADO, so anything Excel can open it can work with.

[SandyDoss]

Marcus,

I know I've said this before:

You are my favorite person in the whole world at this particular point in time.

thanks for the quick response - Sandy