Select printer based on If statement

[Daksport00]

Here is one for you. What I am trying to do is to select a printer, through an existing macro (that used 4.0 macro language, not VB) and sets it as the default.

The purpose for this is to run the macro automated, but different comptuers have a particular printer set to different ports.

=IF({"Canon on Ne03:"},"PRINTER.SETUP{""Canon on Ne03:""}","PRINTER.SETUP{""Canon on LPT2:""}")

Basically, I want the macro to look to port Ne03 for a printer named 'Canon'. If it finds it there then set is as default, if it is not there then set the printer named 'Canon" on port LPT2 as default.

but this doesnt work in code.

Some of your expert help here would be beneficial.

 

[Daksport00]

ok, i finally got this one, after fidling with it for about 4 hours.

Here is the code I had to use:

=IF(R87C32=TRUE)
=PRINTER.SETUP("Canon on Ne03:")
=ELSE()
=PRINTER.SETUP("Canon on LPT2:")
=END.IF()

Cell R87C32 is the second line of the code.

Basically, a bad printer assignment returns a error (#Value!), which cannot be used in a If/Then statement. So the IF statement looks at the first printer assignment, if that is a true assignment, then it will use it, if not then it will use the alternate assignment.