Issue finding rows in excel

[jarle_oudalstoelEN4BR]

Hi all.

I am using an excel file to store date for plate thicknesses. I use ilogic to get the numbers to my parts and that works just fine form my computer but as a different user opens the same part and tries to do the same it's telling him that it cant find the column. Now we are using Vault and we have made sure he's got the excel file. 

I am hoping that someone who's experienced the same has some ideas for how I can resolve this issue. 

[humistonandrew]

Hello,

i have run into something similar. would you please share a snip of your code? i have run into formatting errors where i have begun to look for a range as cells.range("A1").value as an example and had the other person who used my code have their Excel set to R1C1 formatting, this created a conflict and was easy to resolve. 

Another thing to consider, do you use zero based array's, sometimes iLogic and Excel use different basis for the lower bound of an array. if zero or one, as you are counting columns the base is always 1. Once again this is something to check, throwing ideas out there.

Another option is to use a formatted table on your spreadsheet, this allows you to access an array value like coordinates on a chart. i like this approach because i can find the value i want as my search value, then i can read the row as dimensions in an array.

For example with a table you can call the table to get access to it, then run a loop to search the value you are looking for then read that 'row' in the table to extract your data. this helps with more complex tasks but is a good function that i use to search quickly and efficiently.