jmutsche
01-14-2014, 11:50 AM
Hello,
I am trying to figure out how to call a stored process flow from SAS usingvba. I found some information Online... here is my code.
Sub InsertSasDataSet()
Dim sas As SASExcelAddIn
Set sas = Application.COMAddIns.Item("SAS.ExcelAddIn").Object
sas.InsertStoredProcess "P:\HumanDev\QA\Staff\REPORT SPECIALIST\James Mutscheller\My Reports\Weekly\HD\Conversions.egp", Sheet1.Range("A1")
End Sub
I get the error Run time error '-2146233086 (80131502)':
Length cannot be less than zero
Parameter name: length
any help would be greatly appreciated.
I am trying to figure out how to call a stored process flow from SAS usingvba. I found some information Online... here is my code.
Sub InsertSasDataSet()
Dim sas As SASExcelAddIn
Set sas = Application.COMAddIns.Item("SAS.ExcelAddIn").Object
sas.InsertStoredProcess "P:\HumanDev\QA\Staff\REPORT SPECIALIST\James Mutscheller\My Reports\Weekly\HD\Conversions.egp", Sheet1.Range("A1")
End Sub
I get the error Run time error '-2146233086 (80131502)':
Length cannot be less than zero
Parameter name: length
any help would be greatly appreciated.