1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Public Sub ImporterFichier()
'Dim str_fichier_chemin As String
Dim date_user, nom_user, report As String
nom_user = "perp_ve"
date_user = "20130115"
report = Dir("\\appsef\COMMUN\TEC\*" & "*_IA3_data_pv_" & nom_user & "_" & date_user & "_0600*" & "*.csv")
full_name = "\\appsef\COMMUN\TEC\" & report
'Ouverture d'un fichier Excel
Workbooks.OpenText Filename:=full_name, Origin:=xlWindows, _
StartRow:=2, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=True, Comma:=False, Space:=False, Other:=False, FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True
With ActiveWorkbook
'MsgBox Workbooks("test").Sheets.count
.Sheets(1).Copy Before:=Workbooks("test").Sheets(1)
End With
End Sub |
Partager