cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Reeza
Super User Reeza
Super User

Re: Refresh the Excel (xlsx) files Using SAS

Posted 07-25-2022 12:13 PM (1229 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.

 

 

0 Likes
Reply

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 15 replies
  • ‎07-25-2022 10:34 AM
  • 12918 views
  • 6 likes
  • 4 in conversation