select the worksheet

Can someone please tell me asap if this is possible in
Excel!!
The user will be running a macro in which he will be able
to select the workbook name:

IExcelFile = Application.GetOpenFilename("Excel-
files,*.xls", _
1, "Select One File To Open", , False)

I want a perticular sheet to be activated. because this
is the sheet which will be further used by the macro as
the input data. The name of the sheet is different in
different workbooks. So the user must be given an option
to select this sheet.

In other words, just as he is given the option to open
the required workbook, he must be given an option to
open/activate the required worksheet. He must be able to
select the worksheet rather entering the full name of the
sheet.

Can someone please help me with this!! I appreciate any
help.

Regards,
Neeraja.

See one suggestion at your other post.

neeraja wrote:

Can someone please tell me asap if this is possible in
Excel!!
The user will be running a macro in which he will be able
to select the workbook name:

IExcelFile = Application.GetOpenFilename("Excel-
files,*.xls", _
1, "Select One File To Open", , False)

I want a perticular sheet to be activated. because this
is the sheet which will be further used by the macro as
the input data. The name of the sheet is different in
different workbooks. So the user must be given an option
to select this sheet.

In other words, just as he is given the option to open
the required workbook, he must be given an option to
open/activate the required worksheet. He must be able to
select the worksheet rather entering the full name of the
sheet.

Can someone please help me with this!! I appreciate any
help.

Regards,
Neeraja.

--

Dave Peterson