The list of options of the =PRINT function

Ianik

New Member
Joined
Mar 24, 2004
Messages
2
Hi everybody, :biggrin:

A friend of mine sent me a customised Excel Macro.
This Macro at some stage, use the =PRINT() function with some different options in it.

For example: =PRINT(1,,,1,FALSE,FALSE,1,FALSE,1)

This is supposed to send the pritn job to a different Output tray.

But it doesn't work in my case.

I was wondering what are all theses options.
I tried to find the information on every doc I have and on the web, I couldn't find anything. :(

I'd be really really grateful if somebody can shed some lights and get me out of the darkness I am at the moment !!

If you need more info don't hestitate to ask me.

Have a great day.
See you.
Ianik (y)
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

dk

MrExcel MVP
Joined
Feb 15, 2002
Messages
2,942
Hi,

It sounds as though you're referring to an old XLM macro command which has this syntax:-

PRINT(range_num, from, to, copies, draft, preview, print_what, color, feed, quality, y_resolution, selection)

XLM macros are no longer used (although they're still supported) as VBA is now the language used to control Excel. The equivalent command in VBA would be Printout e.g.

ActiveSheet.Printout

HTH
Dan
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

Your best bet to recreate his macro in "modern times" and apply it to what you need would be to use the macro recorder.

Or post back with the code that you have and everyone here can help figure out the kinks.

Hope that helps,

Smitty
 

Ianik

New Member
Joined
Mar 24, 2004
Messages
2
Hi,

Thank you very much to all of you.
Especially dk, it was exactly what I was lookign for ! :biggrin:

I manage to solve my issue !
And finally followed your suggestions and used the Printout function.
I forgot to mentionned that it was an XLM macro !

Althought I have another question about XLM macro.
I need to use a such Macros to print all the Worksheets in a WorkBook.
But the problem is when I change some settings in the Print Driver windows such as different Output Tray, Duplex. It is only taken into effect for the First Worksheet and the others are using the default settings.

This is surely do to the fact that Excel is using a different Print Job for each Worksheet.

As a workaround, I tried to change the Printing Preferences in Windows to be able to select the right options but by Default it seems that Excel is using his own Printing Default Preferences. :eek:

Anybody had this problem before?
Did you find a possible workaround?

Thanks again in advance for all your help.
I will promess a pint of Guinness in a pub for whoever can help me.
But you will have to come to Dublin to taste it !! (y)

See you.
Ianik
A Frenchy living in Ireland ! ;)
 

Watch MrExcel Video

Forum statistics

Threads
1,123,474
Messages
5,601,872
Members
414,479
Latest member
Beau the dog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top