This message shows up only after I run my automation.
The error is showing up right there with the red ! icon.
If you mouse over the name of a property it’ll tell you the datatype it expects. You don’t just put a string in there.
Also, “G1:G3”.ToString is improper. “G1:G3” is already a string, you don’t need .ToString on it.
What you need to put into that property is:
Excel.Sheet("Sheet Name").Range("G1:G3")
One other thing, it looks from your screenshot like you don’t have your For Each Excel Row inside a Use Excel File which also needs to be inside an Excel Process Scope.
2 Likes