topic Re: Import xlsx file with few macro enabled variables into SAS in SAS Programming

Import xlsx file with few macro enabled variables into SAS

sri1 — Wed, 26 Feb 2020 15:08:33 GMT

Hi ,

Can anyone help me with importing a xlsx file(read only access) of which few columns are macro enabled into SAS

Your solutions are highly appreciated.

Thanks

Re: Import xlsx file with few macro enabled variables into SAS

Tom — Wed, 26 Feb 2020 15:24:29 GMT

@sri1 wrote:

Hi ,

Can anyone help me with importing a xlsx file(read only access) of which few columns are macro enabled into SAS

Your solutions are highly appreciated.

Thanks

You need to clarify what you mean. Are you saying the Excel file has macros that run when you open it in Excel? SAS will not (cannot) run any of those. It will just get the current values of the cells in the worksheet(s).

Re: Import xlsx file with few macro enabled variables into SAS

Reeza — Wed, 26 Feb 2020 18:58:10 GMT

Have you tried importing this workbook? If so, what did you try and what isn't working as expected?

@sri1 wrote:

Hi ,

Can anyone help me with importing a xlsx file(read only access) of which few columns are macro enabled into SAS

Your solutions are highly appreciated.

Thanks