Macro Printing

I have a macro writtin using Excel 4.0 Language.

The problem is, I have 2 lines of code that are not working properly.

=PRINTER.SETUP
=PAGE.SETUP

These codes work perfectly using Windows 98 with Excell 2000, but when I
move it to Windows XP with Excel 2003, those lines cause errors.

Any suggestions?

Maybe you want
=PRINTER.SETUP?()
and
=PAGE.SETUP?()
works fine for me in 2003...
Bob Umlas

"Dave" <[email protected]> wrote in message
news:[email protected]...
> I have a macro writtin using Excel 4.0 Language.
>
> The problem is, I have 2 lines of code that are not working properly.
>
> =PRINTER.SETUP
> =PAGE.SETUP
>
> These codes work perfectly using Windows 98 with Excell 2000, but when I
> move it to Windows XP with Excel 2003, those lines cause errors.
>
> Any suggestions?

here is the actual code from the macro

=PRINTER.SETUP("Canon on \\LL_SERVER\GP200_Q")

=PAGE.SETUP("&L&B&08MODEL NO:"&R[-5]C&"
JOB NO:"&R[-4]C&"
S/N:"&R[-3]C&"
&C&""Optim""&B&12L&&L SPECIAL FURNACE CO., INC.
&""Arial""&18P A R T S L I S T
&R&B&08COMPANY:"&R[-6]C&"
REV. NO. OF PARTS LIST:"&R[-2]C&"
DATE:&d","&L&B&10REFERENCE DRAWING NO:"&R[-7]C&"&r&b&10REVISION LEVEL OF
DRAWING:"&R[-1]C&
"
SHEET NO.&P OF
&N",0.25,0.25,1,1,FALSE,TRUE,FALSE,FALSE,1,3,{1,#N/A},1,1,FALSE)

Yes, the second one is quite long.

So are you saying that I should edit the code to be

=PRINTER.SETUP?("Canon on \\LL_SERVER\GP200_Q")


=PAGE.SETUP?("&L&B&08MODEL...


Update: Tried what is written above, no luck


"Bob Umlas" wrote:

> Maybe you want
> =PRINTER.SETUP?()
> and
> =PAGE.SETUP?()
> works fine for me in 2003...
> Bob Umlas
>
> "Dave" <[email protected]> wrote in message
> news:[email protected]...
> > I have a macro writtin using Excel 4.0 Language.
> >
> > The problem is, I have 2 lines of code that are not working properly.
> >
> > =PRINTER.SETUP
> > =PAGE.SETUP
> >
> > These codes work perfectly using Windows 98 with Excell 2000, but when I
> > move it to Windows XP with Excel 2003, those lines cause errors.
> >
> > Any suggestions?
>
>
>