Different files are required for 32-bit or 64-bit versions of Excel. Note that it is quite common to have a 32-bit version of Excel installed on a 64-bit computer. The AQL files used should correspond to the Excel version.
32-bit
The required files will be found in the directory \ANSYS Inc\v242\aqwa\utils\win32\aql32.dll and the supporting DLLs libifcoremd.dll, libifportmd.dll, libmmd.dll, svml_dispmd.dll must be copied to the same directory as the MS Excel executable EXCEL.EXE (for example C:\Program Files (x86)\Microsoft Office\root\Office16\).
64-bit
The required files will be found in the directory \ANSYS-Inc\v242\aqwa\utils\winx64\aql64.dll and the supporting DLLs libifcoremd.dll,libifportmd.dll, libmmd.dll, svml_dispmd.dll must be copied to the same directory as the MS Excel executable EXCEL.EXE (for example C:\Program Files\Microsoft Office\root\Office16\).