1

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.

Pᴇʜ
  • 56,719
  • 10
  • 49
  • 73
Sanjay
  • 11
  • 1
  • $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() – Sanjay Aug 14 '19 at 12:52

0 Answers0