Syntaxfehler

Function CreateProcess Lib "Kernel32" Alias _
"CreateProcessA" ( _
ByVal lpAppName As Long, _
ByVal lpCmdLine As String, _
ByVal lpProcAttr As Long, _
ByVal lpThreadAttr As Long, _
ByVal lpInheritedHandle As Long, _
ByVal lpCreationFlags As Long, _
ByVal lpEnv As Long, _
ByVal lpCurDir As Long, _
lpStartupInfo As STARTUPINFO, _
lpProcessInfo As PROCESS_INFORMATION _
) As Long
Private Declare 

Function WaitForSingleObject Lib "Kernel32" ( _
ByVal hHandle As Long, _
ByVal dwMilliseconds As Long _
) As Long
Private Declare 

Function CloseHandle Lib "Kernel32" ( _
ByVal hObject As Long _
) As Long
'Einige Konstanten benennen
Private Const NORMAL_PRIORITY_CLASS  As Long = &H20&
Private Const INFINITE As Long = -1&
Private Const WAIT_TIMEOUT As Long = 258&
'Einige Datentypen erstellen
Private Type STARTUPINFO
cb As Long
lpReserved As String
lpDesktop As String
lpTitle As String
dwX As Long
dwY As Long
dwXSize As Long
dwYSize As Long
dwXCountChars As Long
dwYCountChars As Long
dwFillAttribute As Long
dwFlags As Long
wShowWindow As Integer
cbReserved2 As Integer
lpReserved2 As Integer
hStdInput As Long
hStdOutput As Long
hStdError As Long
End Type
Private Type PROCESS_INFORMATION
hProcess As Long
hThread As Long
dwProcessID As Long
dwThreadID As Long
End Type

Function NeuesteDatei() As String
Dim fn As String, fd As String
Dim fNeu As String
Dim d As Date
fn = Dir("D:\excel\Neu\1\*.csv")
Do While fn <> ""
fd = Replace(fn, ".csv", "")
If IsDate(fd) Then
If CDate(fd) > d Then
d = CDate(fd)
fNeu = fn
End If
End If
fn = Dir()
Loop
fn = Dir("D:\excel\Neu\1\*.csv")
Do While fn <> ""
Dim versuch As String
If fNeu <> fn And "versuch.csv" <> fn Then
Kill "D:\excel\Neu\1\" & fn & versuch
ShellWait "D:\excel\Neu\1\zusa.bat", 1
Kill "D:\excel\Neu\1\versuch.csv"
Dim Quelle As String, Ziel As String
Quelle = "D:\excel\Neu\1\gesamt.csv"
Ziel = "D:\excel\Neu\1\versuch.csv"
FileCopy Quelle, Ziel
End If
fn = Dir()
Loop
NeuesteDatei = fNeu
End Function


  

  Public 

Sub Sensor1()
Dim r As String
Dim s As String
Dim t As String
Dim u As String
Dim feuchte As String
Dim temp As String
Dim uhr As String
Dim datum As String
ActiveSheet.Unprotect Password:=""
Worksheets("Sensor 1").Activate
ActiveSheet.Range("A20:D65500").Select
Selection.ClearContents
Range("E20").Select
With Worksheets("Sensor 1").QueryTables.Add(Connection:= _
"TEXT;D:\excel\Neu\1\" & NeuesteDatei _
, Destination:=Worksheets("Sensor 1").Range("A20"))
.Name = "Sensor_1"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlOverwriteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.TextFilePromptOnRefresh = False
.TextFilePlatform = xlWindows
.TextFileStartRow = 1
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = True
.TextFileSemicolonDelimiter = False
.TextFileCommaDelimiter = True
.TextFileSpaceDelimiter = False
.TextFileColumnDataTypes = Array(1, 1, 1, 1)
.TextFileDecimalSeparator = "."
.Refresh BackgroundQuery:=False
End With
r = Range("D:D").Rows.Count
feuchte = Range("D:D").Cells(r, 1).End(xlUp).Rows
Cells(16, 20) = feuchte
s = Range("C:C").Rows.Count
temp = Range("C:C").Cells(s, 1).End(xlUp).Rows
Cells(16, 19) = temp
t = Range("B:B").Rows.Count
uhr = Range("B:B").Cells(t, 1).End(xlUp).Rows
Cells(16, 21) = uhr
u = Range("A:A").Rows.Count
datum = Range("A:A").Cells(u, 1).End(xlUp).Rows
Cells(16, 22) = datum
Worksheets("Sensor 1").TextBox7 = Format(Worksheets("Sensor 1").Cells(16, 21), "hh:mm:ss")
Worksheets("Sensor 1").TextBox6 = Format(Worksheets("Sensor 1").Cells(16, 22), "DD:MM:YY")
Range("D21:D212").Select
Selection.Copy
Range("P21").Select
ActiveSheet.Paste
Range("C21:C212").Select
Selection.Copy
Range("O21").Select
ActiveSheet.Paste
Range("N20").Select
Application.CutCopyMode = False
Selection.Copy
Range("P21:P212").Select
Selection.PasteSpecial Paste:=xlAll, Operation:=xlDivide, SkipBlanks:= _
False, Transpose:=False
Range("A10").Select
ActiveSheet.Protect Password:=""
End 

Sub
End Sub


Public 

Function ShellWait(cmdline As String, Optional ByVal _
bShowApp As Boolean = False) As Boolean
'Diese Funktion führt einen Befehl (in CmdLine) aus.
'Dabei wird das sich öffnende Fenster unsichtbar gemacht.
'Diese Funktion wird erst beendet, wenn der Befehl
'vollständig abgearbeitet ist.
'Speicher reservieren
Dim uProc As PROCESS_INFORMATION
Dim uStart As STARTUPINFO
Dim lRetVal As Long
'Die Datentypen initialisieren
uStart.cb = Len(uStart)
uStart.wShowWindow = Abs(bShowApp)
uStart.dwFlags = 1
'Fenster erzeugen
lRetVal = CreateProcess(0&, cmdline, 0&, 0&, 1&, _
NORMAL_PRIORITY_CLASS, 0&, 0&, uStart, uProc)
If lRetVal = 0 Then
MsgBox "Starten der Anwendung ist fehlgeschlagen!", _
vbExclamation vbOKOnly
ShellWait = False
Exit Function
End If
'Warten, bis Fenster beendet wurde
'Dabei das eigene Fenster aktualisieren
Do While WaitForSingleObject(uProc.hProcess, 10) = WAIT_TIMEOUT
DoEvents
Loop
'Wenn man solange warten will, bis die Anwendung beendet
'wird und nicht darauf achtet, dass die wartende Anwendung
'dabei absolut zum Stillstand kommt.
lRetVal = WaitForSingleObject(uProc.hProcess, INFINITE)
'Fenster schließen
lRetVal = CloseHandle(uProc.hProcess)
'Rückgabewert setzen
ShellWait = (lRetVal <> 0)
End Function


bei do while sollte er eine batch datei ausführen was er aber nicht macht

Danke