Programmatically Controlling Excel Viewer

[SLIDE6]

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?

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

"SLIDE6" <root@yourcomputer> wrote in message
news:[email protected]...
> 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?
>
>
>

[NickHK]

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

NickHK

"SLIDE6" <root@yourcomputer> wrote in message
news:[email protected]...
> 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?
>
>
>

[Tom Ogilvy]

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" <[email protected]> wrote in message
news:%[email protected]...
> SLIDE6,
> What are you trying to achieve ?
> Would printing to pdf suffice ?
>
> NickHK
>
> "SLIDE6" <root@yourcomputer> wrote in message
> news:[email protected]...
> > 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?
> >
> >
> >
>
>

[OJ]

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

[NickHK]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:%[email protected]...
> > SLIDE6,
> > What are you trying to achieve ?
> > Would printing to pdf suffice ?
> >
> > NickHK
> >
> > "SLIDE6" <root@yourcomputer> wrote in message
> > news:[email protected]...
> > > 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?
> > >
> > >
> > >
> >
> >
>
>

[SLIDE6]

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" <[email protected]> wrote in message
news:%[email protected]...
> SLIDE6,
> What are you trying to achieve ?
> Would printing to pdf suffice ?
>
> NickHK
>
> "SLIDE6" <root@yourcomputer> wrote in message
> news:[email protected]...
>> 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?
>>
>>
>>
>
>

[SLIDE6]

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" <[email protected]> wrote in message
news:[email protected]...
> You can't control the excel viewer from code - except perhaps with
> sendkeys.
>
> --
> Regards,
> Tom Ogilvy
>
> "SLIDE6" <root@yourcomputer> wrote in message
> news:[email protected]...
>> 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?
>>
>>
>>
>
>

[Tom Ogilvy]

> 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" <[email protected]> wrote in message
news:[email protected]...
> 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
>