Refresh the Excel (xlsx) files Using SAS

☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.

Super User

Re: Refresh the Excel (xlsx) files Using SAS

Posted 07-25-2022 12:13 PM (844 views) | In reply to SASuserlot

1. You can change your workbook to be a macro enabled workbook (XLSM) and then set the workbook to refresh every time it opens.

2. Write a VBS that you can call via SAS to refresh the workbook at a fixed interval.