1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
| directoryname="d:\microf\pmi\Import\"
Set fso = CreateObject("Scripting.FileSystemObject")
set mainfolder=fso.GetFolder(directoryname)
Set filecollection = mainfolder.Files
For Each file In filecollection
Response.Write file.Name & "<BR>"
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = False
'permet d'enregistrer sans confirmation
objExcel.DisplayAlerts = FALSE
M_Fichier = file.Name
//on ouvre le fichier
Set objWorkbook = objExcel.Workbooks.Open("d:\microf\pmi\import\"&M_Fichier)
//on ouvre la premiere feuille
Set objWorksheet = objWorkbook.Worksheets(1)
M_NoPalette = objWorksheet.Cells(1,2)
M_Essence = objWorksheet.Cells(2,2)
M_Qualite = objWorksheet.Cells(3,2)
Response.Write M_NoPalette & " - " & M_Essence & " - " & M_Qualite & "<BR>"
i = 6
M_NoPaquet = objWorksheet.Cells(i,1)
Do While (M_NoPaquet <> "")
M_NoPaquet = objWorksheet.Cells(i,1)
M_Long = objWorksheet.Cells(i,2)
M_Largeur = objWorksheet.Cells(i,3)
M_NbFeuillet = objWorksheet.Cells(i,4)
M_PMS = objWorksheet.Cells(i,5)
Response.Write M_NoPaquet & "; " & M_Long & "; " & M_Largeur & "; " & M_NbFeuillet & "; " & M_PMS & "<BR>"
M_Total_PMS = M_Total_PMS + M_PMS
i = i + 1
Loop
Response.Write M_Total_PMS & "<BR>"
//on sauvegarde le classeur
objWorkbook.Save()
objWorkbook.close()
//on ferme le fichier
objExcel.Quit
Next |
Partager