Erter5
VBA Excel 2003
Programmer sous Excel : Macros et Langage VBA dans la collection Ressources Informatiques
Extrait
&KDSLWUH
$ 3UpVHQWDWLRQ
9%$ ([FHO HVW XQ ODQJDJH GH SURJUDPPDWLRQ RULHQWp REMHW PrPH V·LO QH GLVSRVHSDVGHWRXWHVOHVIRQFWLRQQDOLWpVGHVODQJDJHVGHFHW\SH /D SOXSDUW GHV pOpPHQWV PDQLSXOpV GDQV ([FHO VRQW GHV REMHWV OHV FODV VHXUVOHVIHXLOOHVGHFDOFXOOHVSODJHVGHFHOOXOHVOHVFHOOXOHV /HV REMHWV VRQW RUJDQLVpV VHORQ XQ PRGqOH KLpUDUFKLTXH FHUWDLQV REMHWV FRQWLHQQHQW G·DXWUHV REMHWV TXL SHXYHQW HX[PrPHV HQ FRQWHQLU G·DXWUHV &HV REMHWV VRQW DSSHOpV FRQWHQHXUV RX REMHW 3DUHQW 3DU H[HPSOH O·REMHW $SSOLFDWLRQ HVW OH FRQWHQHXU GHV REMHWV :RUNERRN FODVVHXUV RXYHUWV GDQV ([FHOTXLVRQWHX[PrPHVOHVFRQWHQHXUVGHVREMHWV:RUNVKHHWIHXLOOHVGH FDOFXOG·XQFODVVHXU/HFRQWHQHXUOHSOXVYDVWHHVWO·REMHW$SSOLFDWLRQ 8Q HQVHPEOH G·REMHWV GH PrPH QDWXUH FRQVWLWXH XQH FROOHFWLRQ FROOHFWLRQ :RUNERRNV HQVHPEOH GHV FODVVHXUV RXYHUWV GDQV ([FHO FROOHFWLRQ :RUNVKHHWVHQVHPEOHGHVIHXLOOHVGHFDOFXOG·XQFODVVHXU 8QREMHWGLVSRVHG·XQHQVHPEOHGHFDUDFWpULVWLTXHVDSSHOpHVSURSULpWpVSDU H[HPSOHSRXUO·REMHW$SSOLFDWLRQODSURSULpWp8VHU1DPHUHSUpVHQWHOHQRP GH O·XWLOLVDWHXU OD SURSULpWp 9HUVLRQ UHQYRLH OH QXPpUR GH YHUVLRQ GH 0LFUR VRIW ([FHO HW GH FRPSRUWHPHQWV RX DFWLRQV DSSHOpHV PpWKRGHV SDU H[HP SOHWRXMRXUVSRXUO·REMHW$SSOLFDWLRQODPpWKRGH)LQG)LOHDIILFKHODERvWHGH GLDORJXH2XYULUODPpWKRGH4XLWTXLWWH([FHO 8Q REMHW UpSRQG j GHV pYpQHPHQWV SURYRTXpV SDU O·XWLOLVDWHXU H[ RXYHU WXUHG·XQFODVVHXUFOLFVXUXQERXWRQGHFRPPDQGHFKDQJHPHQWGHFHOOXOH DFWLYHRXSDUOHV\VWqPH /HV FODVVHV VRQW GHV PRGqOHV SHUPHWWDQW GH FUpHU GHV REMHWV GH PrPH QDWXUH /HV REMHWV LVVXV G·XQH PrPH FODVVH KpULWHQW V\VWpPDWLTXHPHQW GH