..:: GiGhEn ::..
2018-03-14 00:04:29 UTC
Salve, avevo bisogno di stampare un modulo in più copie e di far in modo che in queste copie stampate mi uscisse un numero progressivo, e cercando in rete ho trovato questo codice:
-----------
Sub SerialNumber()
'
' SerialNumber Macro
'
'
Dim Message As String, Title As String, Default As String, NumCopies As Long
Dim Rng1 As Range
' Set prompt.
Message = "Inserire il numero di copie che si desidera stampare"
' Set title.
Title = "Print"
' Set default.
Default = "1"
' Display message, title, and default value.
NumCopies = Val(InputBox(Message, Title, Default))
SerialNumber = System.PrivateProfileString("c:\Users\PackardBell\Documents\Settings.Txt", "MacroSettings", "SerialNumber")
If SerialNumber = "" Then
SerialNumber = 1
End If
Set Rng1 = ActiveDocument.Bookmarks("SerialNumber").Range
Counter = 0
While Counter < NumCopies
Rng1.Delete
Rng1.Text = SerialNumber
ActiveDocument.PrintOut
SerialNumber = SerialNumber + 1
Counter = Counter + 1
Wend
'Save the next number back to the Settings.txt file ready for the next use.
System.PrivateProfileString("c:\Users\PackardBell\Documents\Settings.txt", "MacroSettings", "SerialNumber") = SerialNumber
'Recreate the bookmark ready for the next use.
With ActiveDocument.Bookmarks
.Add Name:="SerialNumber", Range:=Rng1
End With
ActiveDocument.Save
If you want the Serial Number to appear in a particular format, e.g. 001, 002, etc, replace the line
Rng1.Text = SerialNumber
with
Rng1.Text = Format(SerialNumber, "00#")
End Sub
-------------------
quando avvio la macro mi da questo errore:
"errore di compilazione" "Prevista funzione o variabile"
evidenziandomi questo nome "SerialNumber" all'interno di questo commento:
' Display message, title, and default value.
non so come correggere questo errore e far si che funzioni.
Grazie
-----------
Sub SerialNumber()
'
' SerialNumber Macro
'
'
Dim Message As String, Title As String, Default As String, NumCopies As Long
Dim Rng1 As Range
' Set prompt.
Message = "Inserire il numero di copie che si desidera stampare"
' Set title.
Title = "Print"
' Set default.
Default = "1"
' Display message, title, and default value.
NumCopies = Val(InputBox(Message, Title, Default))
SerialNumber = System.PrivateProfileString("c:\Users\PackardBell\Documents\Settings.Txt", "MacroSettings", "SerialNumber")
If SerialNumber = "" Then
SerialNumber = 1
End If
Set Rng1 = ActiveDocument.Bookmarks("SerialNumber").Range
Counter = 0
While Counter < NumCopies
Rng1.Delete
Rng1.Text = SerialNumber
ActiveDocument.PrintOut
SerialNumber = SerialNumber + 1
Counter = Counter + 1
Wend
'Save the next number back to the Settings.txt file ready for the next use.
System.PrivateProfileString("c:\Users\PackardBell\Documents\Settings.txt", "MacroSettings", "SerialNumber") = SerialNumber
'Recreate the bookmark ready for the next use.
With ActiveDocument.Bookmarks
.Add Name:="SerialNumber", Range:=Rng1
End With
ActiveDocument.Save
If you want the Serial Number to appear in a particular format, e.g. 001, 002, etc, replace the line
Rng1.Text = SerialNumber
with
Rng1.Text = Format(SerialNumber, "00#")
End Sub
-------------------
quando avvio la macro mi da questo errore:
"errore di compilazione" "Prevista funzione o variabile"
evidenziandomi questo nome "SerialNumber" all'interno di questo commento:
' Display message, title, and default value.
non so come correggere questo errore e far si che funzioni.
Grazie