Alexey
Macros & special formatting (think pivots) get stripped if you run on server, i.e. run a script via autorun or a plugin in a workflow. Otherwise, they are available.
I do know you can set a promoted property in a workflow (value setter), but that information will be in the promoted properties, not the Excel file. I don't now of a VBA way to pull in the workflow step. Maybe someone in the broader audience has ideas?
Best Regards,
Sigrid
------------------------------
Sigrid Kok
Precisely Software Inc.
------------------------------
Original Message:
Sent: 03-11-2023 00:50
From: Alexey Skotnikov
Subject: Get current workflow step to Excel Data File in Excel Workflow
Hi Jayasri,
Yes, I need this in VBA, or if workflow would sync back to Excel file some solution field into some cells is also fine - then I can use formulas.
By the way, it is not accurate that macros are striped out. I am using Excel in workflow with macros at least in 20.3. And even some tutorials from Winshuttle (e.g. FB50 template) has macros.
------------------------------
Alexey Skotnikov
Abbott Rapid Diagnostics AS
Original Message:
Sent: 03-10-2023 11:23
From: Jayasri Varyani
Subject: Get current workflow step to Excel Data File in Excel Workflow
You may be already aware that the User has the Process History option available in the Addin to determine the current workflow step.
If your requirement is to programatically determine the workflow step and use VBA to display instructions, please be aware that VBA won't work in excel files that have been promoted to server. During the promotion process, the macros are stripped out.
------------------------------
Jayasri Varyani
Winshuttle North America
Original Message:
Sent: 03-10-2023 08:31
From: Alexey Skotnikov
Subject: Get current workflow step to Excel Data File in Excel Workflow
Is there any way for Excel as part of Excel Workflow to know on which step it is currently in? We want to show different user instructions in Excel based on workflow step.
Thank you.
------------------------------
Alexey Skotnikov
Abbott Rapid Diagnostics AS
------------------------------