Spreadsheet Control in VBA Form

[promod33]

Hi,
I am using 'Speadsheet Control' in Access VBA form. I have been successful in loading a single worksheet and manipulating the data. Off course,I need to write worksheet name and work book name exactly in the code.

Now, I want to load a workbook. Then,the abovesaid control should be able to display all the worksheets available in that workbook.

Presently,it does display worksheet tab,but its names are default i.e.'Sheet1','Sheet2', etc. And, when I click on 'sheet2' ,it displays blank sheet.

Any help will be appreciated.

Thanks.