Results 1 to 2 of 2

Thread: Excel manipulation

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 2000
    Posts
    4

    Talking

    I search to execute a data processing in each sheet of an excel file without know the name of the sheet.
    similary at that:

    dim NumFeuille as integer

    Do Until (NumFeuille = Fex.ActiveWorkbook.Sheets.count)
    Fex.ActiveWorkbook.Sheets.Item(NumFeuille)
    NumFeuille = NumFeuille + 1
    'traitement
    Loop

    Thanks a lot ... and scuzzi(pardon) for mine english ...
    *****************
    PS : WHHHOUUUAAAZZZZR !!!!!!!!!!!!!!!!
    *****************
    pour les francophones ....
    Je cherche à éxécuter un traitement sur toutes les feuilles d'un fichier Excel en faisant abstraction des noms des feuilles ...
    Qqn a un début de piste?
    MERCI D'AVANCE


  2. #2
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008
    Si vous remplacez "Sheets.Items" avec "Sheets.Select", Il sera OK. OK?

    Pardon mon Francais.

    Cheers,

    Paul.
    Not nearly so tired now...

    Haven't been around much so be gentle...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width