Import xlsx file with few macro enabled variables into SAS

[sri1]

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

[Tom]

---

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

[Reeza]

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

---