Printing all sheets from Explorer

J

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
 
M

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?
Click to expand...

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
 
J

Jan Kronsell

Where do I make the change?

Regards
Jan

Miyahn said:
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
Click to expand...
 
M

Miyahn

Where do I make the change?
Click to expand...

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.
 
J

Jan Kronsell

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

Regards
Jan
 
Top