importing an xlsm file (Windows 10)

[podarum]

Hi, I'm trying to import an xlsm file into SAS and am operating on a Windows 10 machine.  For some reason it's not working.  Any suggestion are greatly appreciated.  Thanks

[japelin]

What does "For some reason it's not working." mean?
Please let me know what you tried and what the results were.
For example, error messages printed in the SAS log window.

Also, it would be better if you have an xlsm file with sample data.

[Tom]

Is it possible to receive the data as a normal XLSX file instead?  SAS will not have any use for any embedded Excel macros the spreadsheet might have it in anyway.

https://www.am18.co.uk/excel-file-types-xlsm-vs-xlsx/#:~:text=XLSM%20doesn't%20take%20up,and%20can%2... 

The biggest downside of XLSX was that you couldn’t store VBA macros. Well, that’s the biggest positive of XLSM. Anytime you try to save a VBA macros file in Excel, you will be prompted to use XLSM because it’s compatible with VBA macros.

[DaanDNR]

proc import with dbms=xlsx should be able to read and excel with the xlsm extension. However you will need to have SAS/ACCESS Interface to PC Files

[podarum · Accepted solution]

The fix happened to be a combination between Windows bit size, Office bit size and SAS installed bit size... they all had to be a 64 bit. Once that was fixed, it worked. Thanks everyone.

[mkeintz]

---

@podarum wrote:
The fix happened to be a combination between Windows bit size, Office bit size and SAS installed bit size... they all had to be a 64 bit. Once that was fixed, it worked. Thanks everyone.

---

Then mark your posting as the solution.