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?

Macro Printing
 

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

"Dave" wrote in message
...
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?

Macro Printing
 

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" wrote in message
...
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?