Servers - General

Re: Unable to auto refresh the excel SFDC connector for HPE

 
Montgomery
Occasional Visitor

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.

AESsuccess

1 REPLY 1
techin
Regular Advisor

Re: Unable to auto refresh the excel SFDC connector for HPE

I think you should reach out to Salesforce team for this query.