probleme impression

  • Initiateur de la discussion philou43
  • Date de début
P

philou43

Guest
comment pouvoir dans un fichier excell imprimer tel feuille avec tel imprimante et qu'une autre feuille soit imprimer sur une autre imprimante
mais que se soit automatique(par défault).
 
Z

Zon

Guest
Salut,

Voici une fonction qui te retourne dans un tableau la liste des imprimantes installées:

Private Declare Function EnumPrintersA Lib "Winspool.drv" _
(ByVal flags As Long, ByVal name As String, ByVal Level As Long, _
pPrinterEnum As Long, ByVal cdBuf As Long, _
pcbNeeded As Long, pcReturned As Long) As Long

Private Declare Function lstrlenA Lib "Kernel32" _
(ByVal lpString As Any) As Long

Private Declare Function lstrcpyA Lib "Kernel32" _
(ByVal lpString1 As String, ByVal lpString2 As Long) As Long

'____________________________________________________________

Private Function Imprimantes()'Laurent Longre

Dim PrinterEnum() As Long, Impr() As String
Dim Needed As Long, Returned As Long, I As Integer

EnumPrintersA 2, vbNullString, 5, 0, 0, Needed, 0
If Needed = 0 Then Exit Function
ReDim PrinterEnum(Needed / 4)
EnumPrintersA 2, vbNullString, 5, PrinterEnum(0), _
Needed, Needed, Returned
ReDim Impr(1 To Returned)
For I = 1 To Returned
Impr(I) = Space$(lstrlenA(PrinterEnum(I * 5 - 5)))
lstrcpyA Impr(I), PrinterEnum(I * 5 - 5)
Next I
Imprimantes = Impr
End Function

Admettons que tu veuilles imprimer la feuille 1 avec l'imprimabnte 1 etc..
dim T
T=imprimantes

sheets(1).printout ,,,T(1)
sheets(2).printout ,,,T(2)

A+++
 

Statistiques des forums

Discussions
312 779
Messages
2 092 045
Membres
105 167
dernier inscrit
JulJon2004