Programmatically Controlling Excel Viewer
 

I'm trying to develop a batch process to print large volumes of XLS files.
I'd like to do that by consuming Excel Viewer 2003 from C#. This process
already runs by late-binding against Excel, but we're not supposed to run
Excel our servers anymore. Anyone have docs or experience controlling Excel
Viewer? Any better ideas?

Programmatically Controlling Excel Viewer
 

You can't control the excel viewer from code - except perhaps with sendkeys.

--
Regards,
Tom Ogilvy

"SLIDE6" <root@yourcomputer wrote in message
...
I'm trying to develop a batch process to print large volumes of XLS files.
I'd like to do that by consuming Excel Viewer 2003 from C#. This process
already runs by late-binding against Excel, but we're not supposed to run
Excel our servers anymore. Anyone have docs or experience controlling
Excel
Viewer? Any better ideas?

Programmatically Controlling Excel Viewer
 

SLIDE6,
What are you trying to achieve ?
Would printing to pdf suffice ?

NickHK

"SLIDE6" <root@yourcomputer wrote in message
...
I'm trying to develop a batch process to print large volumes of XLS files.
I'd like to do that by consuming Excel Viewer 2003 from C#. This process
already runs by late-binding against Excel, but we're not supposed to run
Excel our servers anymore. Anyone have docs or experience controlling
Excel
Viewer? Any better ideas?

Programmatically Controlling Excel Viewer
 

wouldn't you need to run Excel to print to pdf? He said he can't run excel
on the machine that is to print the files - at least that is what I
understood him to say.

--
Regards,
Tom Ogilvy

"NickHK" wrote in message
...
SLIDE6,
What are you trying to achieve ?
Would printing to pdf suffice ?

NickHK

"SLIDE6" <root@yourcomputer wrote in message
...
I'm trying to develop a batch process to print large volumes of XLS
files.
I'd like to do that by consuming Excel Viewer 2003 from C#. This
process
already runs by late-binding against Excel, but we're not supposed to
run
Excel our servers anymore. Anyone have docs or experience controlling
Excel
Viewer? Any better ideas?

Programmatically Controlling Excel Viewer
 

He also said he is writing in C# which means he can control Excel
Viewer, but I think he might want to post on a C# NG rather than on an
Excel one, as he doesn;t even want to use Excel!!!!

Try C-Sharp (C#) NG...
OJ

Programmatically Controlling Excel Viewer
 

Tom
I was thinking a class such as:
http://xoomer.virgilio.it/ellemme/do...DF%201.2.1.zip
to create your own pdf file, avoiding the need for Excel or its print
methods.

Then again depends what the aim is.

NickHK

"Tom Ogilvy" wrote in message
...
wouldn't you need to run Excel to print to pdf? He said he can't run
excel
on the machine that is to print the files - at least that is what I
understood him to say.

--
Regards,
Tom Ogilvy

"NickHK" wrote in message
...
SLIDE6,
What are you trying to achieve ?
Would printing to pdf suffice ?

NickHK

"SLIDE6" <root@yourcomputer wrote in message
...
I'm trying to develop a batch process to print large volumes of XLS
files.
I'd like to do that by consuming Excel Viewer 2003 from C#. This
process
already runs by late-binding against Excel, but we're not supposed to
run
Excel our servers anymore. Anyone have docs or experience controlling
Excel
Viewer? Any better ideas?

Programmatically Controlling Excel Viewer
 

No. Printing to PDF is not acceptable. I happen to really like PDFs, but
the standard format for our digital documents is 1 BPP multipage G4 TIFs.



"NickHK" wrote in message
...
SLIDE6,
What are you trying to achieve ?
Would printing to pdf suffice ?

NickHK

"SLIDE6" <root@yourcomputer wrote in message
...
I'm trying to develop a batch process to print large volumes of XLS
files.
I'd like to do that by consuming Excel Viewer 2003 from C#. This process
already runs by late-binding against Excel, but we're not supposed to run
Excel our servers anymore. Anyone have docs or experience controlling
Excel
Viewer? Any better ideas?

Programmatically Controlling Excel Viewer
 

As it turns out, that isn't right. A little bit of sniffing showed that
Excel Viewer can be controlled via DDE, which is what I'm working to
leverage now. Thanks.

"Tom Ogilvy" wrote in message
...
You can't control the excel viewer from code - except perhaps with
sendkeys.

--
Regards,
Tom Ogilvy

"SLIDE6" <root@yourcomputer wrote in message
...
I'm trying to develop a batch process to print large volumes of XLS
files.
I'd like to do that by consuming Excel Viewer 2003 from C#. This process
already runs by late-binding against Excel, but we're not supposed to run
Excel our servers anymore. Anyone have docs or experience controlling
Excel
Viewer? Any better ideas?

Programmatically Controlling Excel Viewer
 

He also said he is writing in C# which means he can control Excel
Viewer,

I was going by this article:

http://support.microsoft.com/default...b;en-us;211818
XL2000: Cannot Edit Automation Objects in Microsoft Excel Viewer

Now maybe I misinterpreted what is meant by editing automation objects.
Perhaps you can automate it as far as opening and printing.

Perhaps you can elaborate on what is doable in C#

--
Regards,
Tom Ogilvy


"OJ" wrote in message
oups.com...
He also said he is writing in C# which means he can control Excel
Viewer, but I think he might want to post on a C# NG rather than on an
Excel one, as he doesn;t even want to use Excel!!!!

Try C-Sharp (C#) NG...
OJ