I have a workflow that will utilize a macro within an excel template used in many different projects.
Is it possible to structure a re-useable workflow that will accept either a workbook variable being passed OR a string with the workbook path being passed?
In some projects the workbook in question may already be open. In that case, I’d prefer to just pass the workbook variable over so I can keep the workbook open. In other cases, the workbook won’t be opened or initialized yet. In those cases, I would specify the workbook to be used as string/file path.
Is this feasible using something as simple as an if activity to check the argument value? Any downsides I’m not thinking of doing things this way? Should I instead always be passing a string only or a workbook only?