Shell Print doesn't print all pages

  • Thread starter Thread starter A.M
  • Start date Start date
A

A.M

Hi,

If I right click on an xls page and choose print, it doesn't print all
pages. It just print the last page that wes open.

How can i change the shell command to print all pages?

The clue that I found is :
Control Panned => Folder Options => XLS file extention => Advanced => Print
=> Edit ==> DDE Message : [open("%1")][print()][close()]

I think i need to change
the DDE command [open("%1")][print()][close()]
The problem is I can not find the syntax of [print()] shell DDE command.
Could anyone refer me to a link that shows tha sysntax of all shell DDE
commands ?

Any help would be apprecited,
Ali
 
Hi Ali,
I don't think you can.
Open Excel and do a file>print and it will only print the current worksheet.
In Excel you have to group sheets (select more than one with mouse & shift
keys pressed) and then do a file>print to get multipul sheets to print.

As a test you might try grouping some sheets, save the file, close Excel,
and then run your DDE code.


--
John
johnf 202 at hotmail dot com


| Hi,
|
| If I right click on an xls page and choose print, it doesn't print all
| pages. It just print the last page that wes open.
|
| How can i change the shell command to print all pages?
|
| The clue that I found is :
| Control Panned => Folder Options => XLS file extention => Advanced =>
Print
| => Edit ==> DDE Message : [open("%1")][print()][close()]
|
| I think i need to change
| the DDE command [open("%1")][print()][close()]
| The problem is I can not find the syntax of [print()] shell DDE command.
| Could anyone refer me to a link that shows tha sysntax of all shell DDE
| commands ?
|
| Any help would be apprecited,
| Ali
|
|
|
|
 
Back
Top