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
|
Dim MonExcel As Excel.Application, ExlWb As Excel.Workbook
Dim Db As Database
Dim strDir As String
Dim strFileName As String
Dim bytPosRev As Byte
bytPosRev = InStrRev(stDocName, "\")
strDir = Left(stDocName, bytPosRev)
strFileName = Right(stDocName, Len(stDocName) - bytPosRev)
DoCmd.SetWarnings False
Set Db = CurrentDb
'Ouvre excel
Set MonExcel = New Excel.Application
'Désactive les message d'alerte Excel
MonExcel.DisplayAlerts = False
'Ouvre le fichier source qui contient les caractères "." a modifier
Set ExlWb = MonExcel.Workbooks.Open(Filename:=strDir & strFileName)
...
myTransferS MonExcel, ExlWb, "importExcel" |
Partager