Numero de la semaine

Numero de la semaine - VB/VBA/VBS - Programmation

Marsh Posté le 23-05-2005 à 15:46:51    

Bonjour,
je souhaiterais tout simplement savoir quel est la fonction pour recuperer le numero de la semaine en VBA...
 

Reply

Marsh Posté le 23-05-2005 à 15:46:51   

Reply

Marsh Posté le 23-05-2005 à 15:53:59    

peut-être (VB)
 

Code :
  1. Private Sub getWeekNumber()
  2. 'This fantastic bit of code returns the week number
  3. Dim iNumberOfTheWeek As Integer
  4. iNumberOfTheWeek = DatePart("ww", Now())
  6. End Sub


---------------
What if I were smiling and running into your arms? Would you see then what I see now?  
Reply

Marsh Posté le 23-05-2005 à 15:58:07    

Format(Now, "ww", vbMonday)

Reply

Marsh Posté le 23-05-2005 à 18:36:23    

merci :)

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed