Your questions about the HPE Support Center website
1748185 Members
3931 Online
108759 Solutions
New Discussion

Unable to auto refresh the excel SFDC connector for HPE

 
Eve46
New Member

Unable to auto refresh the excel SFDC connector for HPE

I am trying to run a VBA or PS1 file that refreshes the excel connections. But the SFDC connector for HPE salesforce is not connecting.

$app = New-Object -comobject Excel.Application$app.Visible = $True
$wb = $app.Workbooks.Open("C:\Sanjay Kumar\Reports\CaseAge30 - Raw Data.xlsx")
$wb.Name$wb.Refresh$wb.Save()

I ran this command but no luck.