Erter5

Disponible uniquement sur Etudier
  • Pages : 6 (1430 mots )
  • Téléchargement(s) : 0
  • Publié le : 27 mars 2011
Lire le document complet
Aperçu du document
Editions ENI

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  OHVFODV 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 RXYHUWVGDQV ([FHO TXLVRQWHX[PrPHVOHVFRQWHQHXUVGHVREMHWV:RUNVKHHW IHXLOOHVGH 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·XQHQVHPEOHGHFDUDFWpULVWLTXHVDSSHOpHVSURSULpWpV SDU 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)LOHDIILFKHODERvWHGHGLDORJXH2XYULUODPpWKRGH4XLWTXLWWH([FHO  8Q REMHW UpSRQG j GHV pYpQHPHQWV SURYRTXpV SDU O·XWLOLVDWHXU H[  RXYHU WXUHG·XQFODVVHXUFOLFVXUXQERXWRQGHFRPPDQGHFKDQJHPHQWGHFHOOXOH DFWLYH RXSDUOHV\VWqPH /HV FODVVHV VRQW GHV PRGqOHV SHUPHWWDQW GH FUpHU GHV REMHWV GH PrPH QDWXUH /HV REMHWV LVVXV G·XQH PrPH FODVVH KpULWHQW V\VWpPDWLTXHPHQW GHWRXWHVOHVPpWKRGHVSURSULpWpVHWpYpQHPHQWVGHOHXUFODVVHG·RULJLQH,OHVW SRVVLEOHGHFUpHUGHVFODVVHVG·REMHWVDYHF9%$([FHOHQXWLOLVDQWGHVPRGX OHVGHFODVVH



9%$([FHO

/DSURJUDPPDWLRQREMHWVRXV([FHO

% /HPRGqOHREMHWG¶([FHO
 3UpVHQWDWLRQ
&HWWHUHSUpVHQWDWLRQSHUPHWGHGLVWLQJXHUOHVSULQFLSDX[REMHWVHWFROOHFWLRQV G·REMHWVG·([FHO

© (GLWLRQV (1,  $OO ULJKWV UHVHUYHG3URJUDPPHUVRXV([FHO0DFURVHW/DQJDJH9%$



&KDSLWUH

 2EMHWVHW&ROOHFWLRQV
/D OLVWH VXLYDQWH UpVXPH O·XWLOLWp GHV SULQFLSDX[ REMHWV HW FROOHFWLRQV GX PR GqOH /HVREMHWV $SSOLFDWLRQ 2EMHWIDLVDQWUpIpUHQFHjO·DSSOLFDWLRQ0LFURVRIW([FHODFWLYH $QVZHU:L]DUG 2EMHWUHSUpVHQWDQWO·DLGHLQWXLWLYHG·([FHO $VVLVWDQW 2EMHW UHSUpVHQWDQW OH &RPSDJQRQ 2IILFH G·([FHO8WLOLVH] OD SURSULpWp 9L VLEOHSRXUDIILFKHUOH&RPSDJQRQHWODSURSULpWp2QSRXUDFWLYHUOH&RP SDJQRQ $XWR&RUUHFW 2EMHWFRQWHQDQWOHVDWWULEXWVGH&RUUHFWLRQDXWRPDWLTXH0LFURVRIW([FHO $XWR5HFRYHU 2EMHW UHSUpVHQWDQW OHV RSWLRQV GH UpFXSpUDWLRQ DXWRPDWLTXH G·XQ FODV VHXU&HVPDFURVVRQWDFFHVVLEOHVGHSXLV([FHOjSDUWLUGHO·RQJOHW(QUH JLVWUHUGXPHQX2XWLOV2SWLRQV &HOO)RUPDW2EMHW UHSUpVHQWDQW OHV FULWqUHV GH UHFKHUFKH VXU OH IRUPDW GHV FHOOXOHV V·XWLOLVH DYHF OHV SURSULpWpV )LQG)RUPDW HW 5HSODFH)RUPDW GH O·REMHW $SSOLFDWLRQ  'HEXJ 2EMHW SHUPHWWDQW G·DIILFKHU GHV GRQQpHV GDQV OD IHQrWUH ([pFXWLRQ DX PRPHQWGHO·H[pFXWLRQGXFRGH



9%$([FHO

/DSURJUDPPDWLRQREMHWVRXV([FHO 'HIDXOW:HE2SWLRQV 2EMHW FRQWHQDQW OHVDWWULEXWV XWLOLVpV SDU ([FHO ORUV GH O·RXYHUWXUH RX O·HQUHJLVWUHPHQWG·XQHSDJH:HE (UURU&KHFNLQJ2SWLRQV 2EMHWFRQWHQDQWOHVRSWLRQVGHYpULILFDWLRQG·HUUHXUVGHO·DSSOLFDWLRQ([FHO )LOH6HDUFK 2EMHW SHUPHWWDQW G·HIIHFWXHU GHV UHFKHUFKHV GH ILFKLHUV GDQV XQ UpSHU WRLUH /DQJXDJH6HWWLQJV 2EMHWFRQWHQDQWGHVLQIRUPDWLRQVVXUOHVSDUDPqWUHVGHODQJXHG·([FHO 6SHHFK 2EMHW FRQWHQDQW...
tracking img