topic importing an xlsm file (Windows 10) in SAS Programming

importing an xlsm file (Windows 10)

podarum — Thu, 01 Apr 2021 02:29:35 GMT

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

Re: importing an xlsm file (Windows 10)

japelin — Thu, 01 Apr 2021 02:49:10 GMT

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.

Re: importing an xlsm file (Windows 10)

Tom — Thu, 01 Apr 2021 03:19:02 GMT

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%20save%20them%20all.

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.

Re: importing an xlsm file (Windows 10)

DaanDNR — Thu, 01 Apr 2021 10:44:27 GMT

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

Re: importing an xlsm file (Windows 10)

podarum — Mon, 05 Apr 2021 12:37:06 GMT

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.

Re: importing an xlsm file (Windows 10)

mkeintz — Mon, 05 Apr 2021 12:57:17 GMT

@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.