Hello all.
I’m trying to utilize the invoke code activity to run the following code:
Dim xlApp As New Excel.Application
Dim workbook As Excel.Workbook
Dim sheet As Excel.Worksheet
From the looks of it you are trying to invoke the method .Visible on a String object, but the String Class doesn’t contain that method. You need to change your object type. Edit: I didn’t see that you already created the variables as excel objects. I would say check the variable pane and make sure it matches what you are wanting each variable to be.
Here is a link to some info about working with Excel application objects.