ExecuteExcel4Macro "PRINT(........)" - pass parameter as value from cell

[Worf99]

Hi to all,
I need to pass a value from a cell as a parameter (how many copies to print) but the code below does nothing.
No errors but also no execution whatsoever.

Dim numero_copie As Integer
numero_copie = Range("E4").Value
ExecuteExcel4Macro "PRINT(1,,,numero_copie,,,,,,,,2,,,TRUE,,FALSE)"

I also tried this:
ExecuteExcel4Macro "PRINT(1,,,""numero_copie"",,,,,,,,2,,,TRUE,,FALSE)"

Same: nothing.

What am I doing wrong?

Thank you guys!

 

[Eric W]

I haven't tested this, but try:

ExecuteExcel4Macro "PRINT(1,,," & numero_copie & ",,,,,,,,2,,,TRUE,,FALSE)"

 

[Worf99]

Hi Eric,
it works wonderfully!!!!
Thank you so much!!!!!!!
Have a great day!!!
Matt