opening xls file within xlsm file

Getting the errors below when trying to open an xlsm file. Already tried all of the following articles with no success. Please assist

Works fine on windows machines. Doesnt work on mac
Mac monterey 12.1
Excel for mac 16.57

https://stackoverflow.com/questions/65298932/excel-vba-run-time-error-1004-method-getopenfilename-of-object-application

https://answers.microsoft.com/en-us/msoffice/forum/all/problems-working-with-xlsm-files-containing-macros/01d7c6a4-282a-4a61-9376-457ca0787650?auth=1

https://support.microsoft.com/en-us/office/load-the-solver-add-in-in-excel-612926fc-d53b-46b4-872c-e24772f078ca#OfficeVersion=macOS

https://social.msdn.microsoft.com/Forums/office/en-US/84a8567f-0468-4551-890b-05aea34b6c4b/excel-vba-getopenfilename-method-not-working-on-a-mac

https://techcommunity.microsoft.com/t5/microsoft-excel/ct-p/Excel_Cat