>
> Dear Cetin,
> essentially my procedures open and read xls files to import data.
Importing data doesn't have much to do with VBA automation. Preferred way is to use OLEDB or ODBC. And I repeat, seeing the confusion, you shouldn't be worried if it is xls or xlsx. It is not your concern but driver's (or COM object in case of automation). You need an Excel file.
Have a look at this old thread (valid for any version of excel) - ACE.OleDb driver can open any version of excel data:
http://www.foxite.com/archives/vista-excel-compatibility-w-worksheets-0000153776.htm
Cetin Basoz
Give some sample data in code for your question - here is the tool you need to generate the codeMy Blog
PostgreSQL - World's most advanced open source databaseMongoDb Certified Developer
MongoDb Certified DBA
Flutter for mobile, for web & desktop.
The way to
Go.
How to create a Minimal, Reproducible Example