Printing all sheets from Explorer

[Jan Kronsell]

Hi NG.

I have about 100 different workbooks. Normally I would like to print maybe
25 to 50 of them at the same time. I would like to do that from Explorer, so
that I avoid opening all of these workbooks.

The problem is, doing this, it only print the first (active) sheet in each
wokbook, and I like to have all sheets from all selected workbooks printed.

Can this be done in any way?

Jan

 

[Miyahn]

Hi NG.

I have about 100 different workbooks. Normally I would like to print maybe
25 to 50 of them at the same time. I would like to do that from Explorer, so
that I avoid opening all of these workbooks.

The problem is, doing this, it only print the first (active) sheet in each
wokbook, and I like to have all sheets from all selected workbooks printed.

Can this be done in any way?

You can do that by modifying 'Print' context menu.

Change DDE command from
print()
to
print(,,,,,,,,,,,3)

Where the number means,
1:Selected Area, 2:Selected Sheets, 3:All Sheets

 

[Jan Kronsell]

Where do I make the change?

Regards
Jan

in message news:#[email protected]

You can do that by modifying 'Print' context menu.

Change DDE command from
print()
to
print(,,,,,,,,,,,3)

Where the number means,
1:Selected Area, 2:Selected Sheets, 3:All Sheets

 

[Miyahn]

Where do I make the change?

In the registry.
(Start -> run -> regedit.exe)

For Excel97 or later, keys are
HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Print\ddeexec
and
HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Print\ddeexec\ifexec

Note:
Editing of the registry is a little dangerous.
Export the key before editing.
Exported *.reg file can be imported by double-clicking.

 

[Jan Kronsell]

Thank you. I wasn't able to find the right key, just searching in the
registry for Excel.

Regards
Jan