[OnJobEnd do a macro and print the result of Macro]

Thank you for reply, i understand.

 

after compose the pdf add on job end is possible to restart read file excel from first record

 

and compose ather file below first composition??

 

Can you write me the code??

[OnJobEnd do a macro and print the result of Macro]

Hi,

Is it possible that when Job end, fusion pro take a macro on a excel data and restart to print variable date the result of a macro .

 

I attach the macro that i have on a excel and that write on sheet 2.

 

Now i create a file for fusion pro for print variable data and after i create another file from sheet 2 for print the variable data from result to macro.

 

Sub Estrai()

Dim Coll As New Collection

Dim uRiga As Long

Dim Righe As String

Dim Matrix As Variant

Dim Arr

Dim i As Integer

Dim y As Integer

 

 

'determina l'ultima riga

uRiga = Foglio1.Range("A" & Rows.Count).End(xlUp).Row

 

 

'carica la tabella in matrice

Matrix = Foglio1.Range("A1:L" & uRiga)

 

 

'esculde i duplicati

On Error Resume Next

For i = 2 To uRiga

Coll.Add i, CStr(Foglio1.Cells(i, 12) & Foglio1.Cells(i, 1) & Foglio1.Cells(i, 2))

Next

On Error GoTo 0

 

 

'genera matrice con le righe univoche

For i = 1 To Coll.Count

Righe = Righe & " " & Coll(i)

Next

Righe = Trim(Righe)

 

 

'estrae dalla matrice principale una matrice filtrata senza duplicati

Arr = Application.Index(Matrix, Application.Transpose(Split(Righe)), Array(12, 1, 2, 10))

 

 

'azzera il 4^ campo della matrice

For i = 1 To UBound(Arr)

Arr(i, 4) = 0

Next

 

 

'somma nel 1^ campo della matrice ogni dato univoco

For i = 1 To UBound(Arr)

For y = 1 To UBound(Matrix)

If Arr(i, 1) = Matrix(y, 12) And Arr(i, 2) = Matrix(y, 1) And Arr(i, 3) = Matrix(y, 2) Then

Arr(i, 4) = Arr(i, 4) + Matrix(y, 10)

End If

Next y

Next i

 

 

'scrive le intestazioni

Foglio2.Range("A1") = "Ciao"

Foglio2.Range("B1") = "come"

Foglio2.Range("C1") = "stai"

Foglio2.Range("D1") = "ok"

 

 

'scrive la matrice su foglio

Foglio2.Range("A2").Resize(UBound(Arr), 4) = Arr

 

 

End Sub

 

 

Thank you

[ss_noConnect JDF]

Hi,

Have anyone this problem with JDF works? I use Efi EB-32 v 2.0

Thanks!

[Change pdf page but not text box]

Hi,

Can I replace the image of the pdf page by leaving the text boxes in place?

And can I move all the text boxes together in a layout?

Thanks

[Insert a calculation in a rule instead of a field]

Perfect !! Gracias

[Insert a calculation in a rule instead of a field]

Hi,

Can i insert a calculation in a rule instead of a field??

Now i write a calculation in a field of a excel and fusion pro read the result.

Would i that fusion pro make the calculation by most field to excel.

For example now in field A2 i write =B2+(C3/H4) after i want write in a rule (Field(" Prezzo") +(Field("Vendite")/(Field("Prodotti")... is it possible??

Thanks

[insert in a fusion pro template a page of a PDf]

Thank you so much!!

[insert in a fusion pro template a page of a PDf]

Hi, it's work good!!

And if would i change proportion in a rule?

It's possible??

Thanks!

[insert in a fusion pro template a page of a PDf]

Ah wonderfull!!

But can i select a page of pdf by a field of file excel?

And have i create a new rule? In ghrapics frame What should I write?

Thanks!!

[Data-driven paper selection?]

HI, i use switch tray and is it possible that we compose a jdf by 20 record all work good while we compose a jdf by 200 record, my print (Ricoh pro 8100se ) the paper was switched randomly?

JDF doesn't work with more record? or the problem is JMF??

PS in FP 9.36 postscript don't read Too many repeated text boxes on a page.

Why?

[insert in a fusion pro template a page of a PDf]

Hi,

Can i insert in a image box a page of PDF with a excel field.

a PDF have a 100 page and i want insert in fusion Pro a page of PDF.

For example i write in a field a directory of a pdf (c:prova/prova.pdf/page1)

Exist this method?

Thanks

[Create a JDF file on a client and then move to the Rip]

Ok, thanks!!!

[Create a JDF file on a client and then move to the Rip]

Hi, i've a 9.36 fusion Pro version on a acrobat DC and i print the files on command workstation in Server EB 32.

How can i set fusion pro for create a jdf file on my computer client?

Now i select on fusion pro compose , output PDF and in JDF , create jdf and send to server with IP address.

If a don't send JDF file in compose to IP address, fusion pro create two file, ( 1 pdf and 1jdf ) that command workstation read a ppml and doesn't print.

Thanks