ExcelBanter - How to choose a sheet in a workbook with the old Excel XLM ?

I don't know that much about XLM, but this might be the method you're
looking for:

WORKBOOK.SELECT
Macro Sheets Only

Equivalent to selecting a sheet or group of sheets in the active workbook.
If you select a group of sheets, subsequent commands effect all the sheets
in the group.

Syntax

WORKBOOK.SELECT(name_array, active_name, replace)

Name_array is a horizontal array of text names of sheets you want to
select. If name_array is omitted, no sheets are selected.

Active_name is the name of a single sheet in the workbook that you want
to be the active sheet. If active_name is omitted, the first sheet in
name_array is made the active sheet.

Replace specifies whether the currently selected sheets or macro sheets
are to be replaced by name_array. If TRUE or omitted, then the current sheet
selection is replaced by name_array. If FALSE, then name_array will be
appended to the current sheet.

-Erik

"erfani" wrote in message
...

Hi,

I have an old XLM macro which runs just fine for my needs. The only
thing I have not managed to do is to be able to select not just an
excel workbook but a given sheet of that workbook. Is there any
command or way of making it choose the proper sheet of the workbook
before executing itself ?

Any suggestion is welcome !

Cheers
Nader

--
erfani
------------------------------------------------------------------------
erfani's Profile:
http://www.excelforum.com/member.php...o&userid=15918
View this thread: http://www.excelforum.com/showthread...hreadid=273953