Creating SAS Profile

[Dreamer]

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

[Patrick]

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

[Dreamer]

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