https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-refresh/m-p/638622#M2472 <P>Hi,</P><P>I have a vba code to refresh sas programs like below, earlier the code executed without any error. Now i am facing "value cannot be null" error. Parameter:contentInfo" error. Any idea on this.</P><P>&nbsp;</P><P>dim SAS as sasexceladdin</P><P>set SAS=application.comaddins.item("SASExceladdin").object</P><P>SAS.Refresh ("DATA")</P><P>SAS.Refresh (SASApp_WORK_Data)</P><P>&nbsp;</P><P>Where "DATA" is my program imported in excel via addin.</P><P>&nbsp;</P><P>kindly help!</P> Thu, 09 Apr 2020 09:26:31 GMT Nsp96 2020-04-09T09:26:31Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-refresh/m-p/638622#M2472 <P>Hi,</P><P>I have a vba code to refresh sas programs like below, earlier the code executed without any error. Now i am facing "value cannot be null" error. Parameter:contentInfo" error. Any idea on this.</P><P>&nbsp;</P><P>dim SAS as sasexceladdin</P><P>set SAS=application.comaddins.item("SASExceladdin").object</P><P>SAS.Refresh ("DATA")</P><P>SAS.Refresh (SASApp_WORK_Data)</P><P>&nbsp;</P><P>Where "DATA" is my program imported in excel via addin.</P><P>&nbsp;</P><P>kindly help!</P> Thu, 09 Apr 2020 09:26:31 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-refresh/m-p/638622#M2472 Nsp96 2020-04-09T09:26:31Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-refresh/m-p/643317#M2474 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/321753">@Nsp96</a>&nbsp;</P> <P>&nbsp;</P> <P>Double-check that you have enabled the SAS Add-in VBA reference.&nbsp;</P> <P>&nbsp;</P> <P>Does this work?</P> <P>&nbsp;</P> <P><FONT face="courier new,courier">Sub test()</FONT><BR /><FONT face="courier new,courier">&nbsp; Dim SAS As SASExcelAddIn</FONT><BR /><FONT face="courier new,courier">&nbsp; Set SAS = Application.COMAddIns.Item("SAS.ExcelAddin").Object</FONT><BR /><FONT face="courier new,courier">&nbsp; SAS.Refresh ThisWorkbook</FONT><BR /><FONT face="courier new,courier">End Sub</FONT></P> Mon, 27 Apr 2020 15:20:40 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-refresh/m-p/643317#M2474 fifthand57th 2020-04-27T15:20:40Z