cancel
Showing results for 
Search instead for 
Did you mean: 

Excel VBO Error ("Cannot find column X")

MenardoEspectac
Level 2
I just want to inquire about an issue we are encountering with regards to a process that uses Excel VBO on a Windows 10 environment with Office 365. The step is that we are trying to copy a range of cells from an excel file and we are using an action stage to pass parameters to action Get Worksheet Range as Collection. The premise is, this stage works on Windows 7 with Office 2013, but an issue arises when we run on the environment I have indicated above. For example, if we are trying to copy a range of A1:AL960, everything works fine. Beyond that (A1:AL961) we get the error "Internal : Could not execute code stage because exception thrown by code stage : Cannot find column 38.". There are different levels that this error occurs and I have findings that this is not connected to any maximum numbers of cells that is allowable to be copied. For example, A1:AL960 is 3640 cells. While A1:V3524 is 81052 cells and both ranges works. Although, one additional row would give us the error. The VBO object we are using is GetWorksheetRangeAsCollection. Any ideas? or has anyone experienced this in the past? Thanks a lot...
10 REPLIES 10

BernardoCris012
Level 3

Maybe you can try getting the total number of rows first, then use that as the last row for your range. For example you have data item output as "Number of Rows" instead of A1:AL190 as range use "A1:AL" & [Number of Rows]. Sometimes there are rows that has hidden value.