|
-
Nov 13th, 2000, 09:01 AM
#1
Thread Starter
New Member
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|