hi guys im trying to read multiple excel files, this is my workflow
i get an error saying “Object reference not set to an instance” of an object and the workbook value is null. the message box doesn’t even show up
i have another workflow that i think it’s the same with the 1st one
Try using the Get Workbook sheets activity to get the sheets available in the file you have opened under excel application scope. Set the output of the get excel sheets header to an output variable. Then use a For Each activity to loop through the sheets that are held by that variable…