My data exists in two excel workbooks book1, and book2. Each book contains 8 columns. I want to fetch 3 columns from sheet1 of book1 and 4 columns from sheet1 of book2 in the datagrid controll designed in visual basic 6.0 whenever I click on the button "Get Data"