Very Computer

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.

Thanks

Please post the code - it seems you need to use "Sheet2" name in say
workbookObject.sheets("Sheet2").Activate to have this by your "ActiveSheet"

ChrisMyrs

Quote:> 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.

> Thanks