The list of options of the =PRINT function

[Ianik]

Hi everybody,

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

 

[RalphA]

Ididn't find any PRINT function in Excel 97 SR-1.

 

[dk]

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]

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]

Hi,

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

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.

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 !!

See you.
Ianik
A Frenchy living in Ireland !