I am trying to open Excel Sheet through Ms Access using vb module. There
are two excel sheets one has 4 columns and 6 rows and another has 11
cols and 10 rows. When first sheet is opened it works fine but for the
second sheet it always defaults to the 4 cols and 6 rows sheet. Please
let me know where I am going wrong.