I am trying to invoke VBA or Execute a macro that will run on all workbooks open on the users computer. The issue is that when I run within the excel application scope, the only workbook picked up by Application.workbook in the VBA is the one referenced by the excel application scope. I want to avoid using open application activity to manually run the VBA because I want to use UiPath to pass an argument through the VBA. Let me know if you have any ideas!
I do and this is the methodology I used. However, for some reason when it is run within the excel application scope, the only workbook recognized by Application.Workbooks is the workbook referenced by the excel application scope!
To further clarify, lets say all I want to do is present the name of every open Excel workbook in a message box. I would have:
Dim wb as workbook
For Each wb in Application.Workbooks
This would not return the names of all open workbooks, rather it would only return the name of the workbook in the excel application scope.