SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Send Alt-E keystrokes to Excel from SAS

Reply
Occasional Contributor
Posts: 8

Send Alt-E keystrokes to Excel from SAS

I'm curious if there is a way that I can send the keystrokes ALT-E (the letter E) to Excel from SAS. Currently I'm opening and calling an Excel macro from SAS. However, when the spreadsheet opens there is a pop-up box asking if I want to disable or enable macros.

Is there a way that I can send a command to Excel to either automatically enable macros or actually send the keystrokes necessary to Excel (ALT-E)?

Thanks.
Ask a Question
Discussion stats
  • 0 replies
  • 171 views
  • 0 likes
  • 1 in conversation