I used the macro recorder to work with some groups and have run across the
following line of code:

ExecuteExcel4Macro "SHOW.DETAIL(1,2,TRUE,,41)"

What the heck does this do/mean? What are the different parammeters in
"SHOW.DETAIL(?,??,???,????,?????)"

Thanks in advance,

Christmas May

Check this link out it has a list of excel 4.0 macros as a help file

http://office.microsoft.com/en-us/as...475331033.aspx

once installed it should have help for all those extra excel4.0macros

"ChristmasMay" wrote:

I used the macro recorder to work with some groups and have run across the
following line of code:

ExecuteExcel4Macro "SHOW.DETAIL(1,2,TRUE,,41)"

What the heck does this do/mean? What are the different parammeters in
"SHOW.DETAIL(?,??,???,????,?????)"

Thanks in advance,

Christmas May

But there used to be a problem with the help file referenced in that link: it
can be installed ONLY if you are running Excel 2000. The file is an EXE with
an installer that checks the version and won't install the help file if you
are runnning Excel 2002 (or, I presume, Excel 2003). Since the date on the
file is 1999, it doesn't look to me like they've fixed the bug.

SHOW.DETAIL expands part of an outlined list. Here is what you fnd in the help
file for this function:

"
SHOW.DETAIL(rowcol, rowcol_num, expand, show_field)

Rowcol is a number that specifies whether to operate on rows or columns of
data.

Rowcol Operates on
1 Rows
2 Columns
3 The current cell's row or column. The second argument, rowcol_num, is then
ignored.


Rowcol_num is a number that specifies the row or column to expand or collapse.
If you are in A1 mode, you must still give the column as a number. If
rowcol_num is not a summary row or column, SHOW.DETAIL returns the #VALUE!
error value and interrupts the macro.

Expand is a logical value that specifies whether to expand or collapse the
detail under the row or column. If expand is TRUE, Microsoft Excel expands the
detail under the row or column; if FALSE, it collapses the detail under the
row or column. If expand is omitted, the detail is expanded if it is currently
collapsed and collapsed if it is currently expanded.

Show_Field is a string specifying the name of the field to add to a PivotTable
report, if the selection is inside a PivotTable report. The new field is added
as the new innermost field. Available for only innermost row or column fields.
"

If you want the help file I can email it to you. Copy it to this directory for
Excel XP.

C:\Program Files\Microsoft Office\Office10\1033

For Excel 2003, change Office10 to Office11

If those paths aren't correct for you, use Windows' Search to find the
existing XLMACRO.CHM file and copy the full file over it.

On Fri, 25 Feb 2005 11:53:04 -0800, ben wrote:

Check this link out it has a list of excel 4.0 macros as a help file

http://office.microsoft.com/en-us/as...475331033.aspx

once installed it should have help for all those extra excel4.0macros

"ChristmasMay" wrote:

I used the macro recorder to work with some groups and have run across the
following line of code:

ExecuteExcel4Macro "SHOW.DETAIL(1,2,TRUE,,41)"

What the heck does this do/mean? What are the different parammeters in
"SHOW.DETAIL(?,??,???,????,?????)"

Thanks in advance,

Christmas May

Hi Myrna,
Do you know of another place to get info about those ExecuteExcel4Macro XLM
macros.
I want to know if is is possible to specify the password for workbook when I
get the data fron a closed workbook.
Thanks.
--
Jac Tremblay


"Myrna Larson" wrote:

But there used to be a problem with the help file referenced in that link: it
can be installed ONLY if you are running Excel 2000. The file is an EXE with
an installer that checks the version and won't install the help file if you
are runnning Excel 2002 (or, I presume, Excel 2003). Since the date on the
file is 1999, it doesn't look to me like they've fixed the bug.

SHOW.DETAIL expands part of an outlined list. Here is what you fnd in the help
file for this function:

"
SHOW.DETAIL(rowcol, rowcol_num, expand, show_field)

Rowcol is a number that specifies whether to operate on rows or columns of
data.

Rowcol Operates on
1 Rows
2 Columns
3 The current cell's row or column. The second argument, rowcol_num, is then
ignored.


Rowcol_num is a number that specifies the row or column to expand or collapse.
If you are in A1 mode, you must still give the column as a number. If
rowcol_num is not a summary row or column, SHOW.DETAIL returns the #VALUE!
error value and interrupts the macro.

Expand is a logical value that specifies whether to expand or collapse the
detail under the row or column. If expand is TRUE, Microsoft Excel expands the
detail under the row or column; if FALSE, it collapses the detail under the
row or column. If expand is omitted, the detail is expanded if it is currently
collapsed and collapsed if it is currently expanded.

Show_Field is a string specifying the name of the field to add to a PivotTable
report, if the selection is inside a PivotTable report. The new field is added
as the new innermost field. Available for only innermost row or column fields.
"

If you want the help file I can email it to you. Copy it to this directory for
Excel XP.

C:\Program Files\Microsoft Office\Office10\1033

For Excel 2003, change Office10 to Office11

If those paths aren't correct for you, use Windows' Search to find the
existing XLMACRO.CHM file and copy the full file over it.

On Fri, 25 Feb 2005 11:53:04 -0800, ben wrote:

Check this link out it has a list of excel 4.0 macros as a help file

http://office.microsoft.com/en-us/as...475331033.aspx

once installed it should have help for all those extra excel4.0macros

"ChristmasMay" wrote:

I used the macro recorder to work with some groups and have run across the
following line of code:

ExecuteExcel4Macro "SHOW.DETAIL(1,2,TRUE,,41)"

What the heck does this do/mean? What are the different parammeters in
"SHOW.DETAIL(?,??,???,????,?????)"

Thanks in advance,

Christmas May