Link to different rows of XLS?

[mslosar]

My guess is this isn't do-able for some reason.

At any rate, i have an excel file for a piece of equipment we make. It's about 300 lines long in sheet1. In order to try and speed things up, i've been breaking down sheet 1 into sections. So

Main Body goes from A2-A16,

AssemblyB goes from A19-A30

AssemblyC goes from A34-78

etc

Point being, why load 300 lines of variables into a piece requiring only 5.

Using 'START CELL' you can start the excel file off wherever you want. What i'd like is to be able to have read lines A2-16 and, say, A159-A168 in the same file. When trying to add the excel file a second time (even with a new start cell) it says can't load the excel file twice and no syntax i've found yet in the start cell lets you pick multiple starting points.

Is there anyway to do this?

[mslosar]

No one's tried this?

[pball]

This should be possible using iLogic coding. I haven't personally done this but there should be examples around the forum of using iLogic to read an excel file into parameters.

[mslosar]

It's not worth the effort to go through ilogic and open yet another session of excel when it's already being done on open.

If I can specify that I would like to read in parameters starting with Sheet1 A1, seems logical to want to be able to add mutliple sections from time to time as well.

The ilogic routines allow you to go get whatever cells you want, and I suppose a range as well.

The preferable method would be adding file1.xlsx and start cell A1 and to be able to link the same file again, file1.xlsx but have it start at A160. Doesn't seem difficult to me or having any potential issues like cyclic redundancy or anything - but yet, seemingly it's banned. Be nice to know if that's true or if i'm just doing it wrong somehow.