BookmarkSubscribeRSS Feed
Dreamer
Obsidian | Level 7

Hi,

I have created a Excel VBA utility for my business users where on button click it runs a SAS stored procedure and refreshes excel with newly created data sets.

There are many users of this report and most of them don't know how to configure SAS profile in Excel SAS Add in.

Most of the time I get complains that utility is not working. But the real problem is that they have not configured the profile in SAS Add in.

So I am looking for a way to automatically configure SAS profile if its not been configured.

Currently I got a way to check if profile is configured or not. But can't configure it as its a read only property!!

Dim SAS As SASExcelAddIn

    Set SAS = Application.COMAddIns.Item("SAS.ExcelAddIn").Object

    If Trim(SAS.ActiveProfile.Name) = "" Then

        MsgBox "Please configure your SAS profile!", vbInformation

End If

2 REPLIES 2
Patrick
Opal | Level 21

You could also write some step by step instructions and then add a link to these instructions as part of your message.

Dreamer
Obsidian | Level 7

Hi , I've already done that but its less useful!!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 2 replies
  • 1248 views
  • 0 likes
  • 2 in conversation