Servers - General

Unable to auto refresh the excel SFDC connector for HPE

 
kuznetsovarte
Occasional Contributor

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. www.upsers.com

$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.