Running macro through PowerShell

Question

I want to run a macro through a PowerShell script. I figured out how to start the macro.

$ExcelPath = "R:\01.DS\04.X-DS\13. Proposed plan\Proposed_plan_WINGS.xlsm"
$Excel = New-Object -ComObject Excel.Application
$Excel.Visible = $true
$Workbook = $Excel.Workbooks.Open($ExcelPath)
$Worksheets = $Workbooks.Worksheets
$Worksheet = $Workbook.Worksheets.Item(1)

$Excel.Run('Iris_prop_plan')

However, when the macro starts, a popup appears which says: update values. How do I include this in the code?

Possible duplicate of Prevent the “Update Values:” dialog box from opening every time a cell with a link is modified. — Ansgar Wiechers
– Ansgar Wiechers, Commented Sep 7, 2017 at 9:32
this does not work for me is a little vague. There were 3 suggestions in that linked post. You tried all of them and it changed nothing and you still get the problem? If it didnt help I would add what you specifically tried as an edit to the question. — Matt
– Matt, Commented Sep 7, 2017 at 11:32
Hi, "displayalerts is false" stops showing the popupbox, but the macro is leaving out key steps linked with adding the values. "xlUpdateLinksNever" is not recognized as a command in powershell. — Steff
– Steff, Commented Sep 7, 2017 at 13:33
[Microsoft.Office.Interop.Excel.Constants]::xlUpdateLinksNever. Aside from that I doubt we can do anything else without knowing the code of your macro. — Ansgar Wiechers
– Ansgar Wiechers, Commented Sep 7, 2017 at 13:43

Steff · Accepted Answer · 2018-11-14 20:10:34Z

1

# start Excel
$excel = New-Object -comobject Excel.Application
#open file
$FilePath = 'FilePath'
$workbook = $excel.Workbooks.Open($FilePath)
##If you will like to check what is happend
$excel.Visible = $true
## Here you can "click" the button
$app = $excel.Application
$app.Run("MacroName")

       ##The macro name is the trigger of your button

answered Nov 14, 2018 at 20:10

Steff

1432 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Running macro through PowerShell

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related