Store printer name to variable

[Jeff Barnes]

Hi everybody,

I am using OLE to access Excel. What I need to do is open the Printer
Selection dialog and store the printer name to a variable.

I can open the dialog by using:
oExcelialogs(8):Show()

if I try to use a variable to store this it just returns .F.
cPrinter := oExcelialogs(8):Show() (Returns .F.)

Any Ideas?

TIA
Jeff

 

[Nick Cranham]

Jeff,
Is this VB ?

NickHK

 

[Jeff Barnes]

Nice,

No not VB, I'm using Clipper / Fivewin, but, if you can show me how to do it
in VB I think I can figure it out.

I have found a work-around for now...

First I use the oExcelialogs(8):Show() to set the active printer then
I use crinterExcel:Get("ActivePrinter") to store the printer name to
cPrinter.
The only problem with this is that right after oExcelialogs(8):Show() it
flashes the excel screen for a second (I have set oExcel:Visable:= .t.) but
it still flashes ... I think I can live with this.

Jeff

 

[Jeff Barnes]

Opps, Should have been NICK not NICE (although I'm sure Nick is Nice
lol)

Jeff

 

[Jeff Barnes]

Another correction ... Visable is set to .f. not true. (I really shoud
re-read before I send ... Sorry about that)

Jeff