Hi,

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

Any suggestion is welcome !

Cheers
Nade

--
erfan
-----------------------------------------------------------------------
erfani's Profile: http://www.excelforum.com/member.php...fo&userid=1591
View this thread: http://www.excelforum.com/showthread.php?threadid=27395

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