Hi
I am trying to load an Excel file that contains many
sheets. I have to select only certain range of columns
which i am able to select and pass it on to a table. Now
there is two columns which don't fall into this range but
needed to be loaded as a separate columns in the same
table. Can i use a constant cell to pass along with the
range of cells. Is there any sample source where i can
find that....
The other issue is this Excel file is linked to another
file for some other purposes (not related to the range we
load into the table).. So each time when my Script runs,
it pops up a window saying do you want to link the other
Excel file. Is there 'disconnected edit' property that i
can use to say'No' automatically...

Thanks a lot for your help
l