I try to get the newest .xls file in a directory. Anyone sees why me method
brings up an error and doesnt find the files ? There are files in the ginven
directory.

Public ZMappe As String

Sub Auto_Open()

Dim Dat As Date
Dim DatVgl As Date
Dim Mappe As String

Const s = _
"F:\Siemens"
Mappe = Dir(s & "\*.xls")
Dat = FileDateTime(s & "\" & Mappe)

Do Until Mappe = ""
DatVgl = FileDateTime(s & "\" & Mappe)
If DatVgl Dat Then
Dat = DatVgl
ZMappe = s & "\" & Mappe
End If
Mappe = Dir()
Loop

Workbooks.Open Filename:=ZMappe

End Sub

Code worked OK for me.

--
Regards,
Tom Ogilvy


"Philipp Oberleitner" wrote in message
...
I try to get the newest .xls file in a directory. Anyone sees why me
method
brings up an error and doesnt find the files ? There are files in the
ginven
directory.

Public ZMappe As String

Sub Auto_Open()

Dim Dat As Date
Dim DatVgl As Date
Dim Mappe As String

Const s = _
"F:\Siemens"
Mappe = Dir(s & "\*.xls")
Dat = FileDateTime(s & "\" & Mappe)

Do Until Mappe = ""
DatVgl = FileDateTime(s & "\" & Mappe)
If DatVgl Dat Then
Dat = DatVgl
ZMappe = s & "\" & Mappe
End If
Mappe = Dir()
Loop

Workbooks.Open Filename:=ZMappe

End Sub

Hmm
dont understand why it brings error


"Tom Ogilvy" schrieb im Newsbeitrag
...
Code worked OK for me.

--
Regards,
Tom Ogilvy


"Philipp Oberleitner" wrote in message
...
I try to get the newest .xls file in a directory. Anyone sees why me
method
brings up an error and doesnt find the files ? There are files in the
ginven
directory.

Public ZMappe As String

Sub Auto_Open()

Dim Dat As Date
Dim DatVgl As Date
Dim Mappe As String

Const s = _
"F:\Siemens"
Mappe = Dir(s & "\*.xls")
Dat = FileDateTime(s & "\" & Mappe)

Do Until Mappe = ""
DatVgl = FileDateTime(s & "\" & Mappe)
If DatVgl Dat Then
Dat = DatVgl
ZMappe = s & "\" & Mappe
End If
Mappe = Dir()
Loop

Workbooks.Open Filename:=ZMappe

End Sub

Could it be that the first time through it found the newest--and you didn't keep
track of that first filename?

Option Explicit

Sub Auto_Open()

Dim Dat As Date
Dim DatVgl As Date
Dim Mappe As String
Dim ZMappe As String '<-- added

Const s = _
"c:\temp"
Mappe = Dir(s & "\*.xls")
Dat = FileDateTime(s & "\" & Mappe)

ZMappe = s & "\" & Mappe '<-- added

Do Until Mappe = ""
DatVgl = FileDateTime(s & "\" & Mappe)
If DatVgl Dat Then
Dat = DatVgl
ZMappe = s & "\" & Mappe
End If
Mappe = Dir()
Loop

Workbooks.Open Filename:=ZMappe

End Sub

Philipp Oberleitner wrote:

Hmm
dont understand why it brings error

"Tom Ogilvy" schrieb im Newsbeitrag
...
Code worked OK for me.

--
Regards,
Tom Ogilvy


"Philipp Oberleitner" wrote in message
...
I try to get the newest .xls file in a directory. Anyone sees why me
method
brings up an error and doesnt find the files ? There are files in the
ginven
directory.

Public ZMappe As String

Sub Auto_Open()

Dim Dat As Date
Dim DatVgl As Date
Dim Mappe As String

Const s = _
"F:\Siemens"
Mappe = Dir(s & "\*.xls")
Dat = FileDateTime(s & "\" & Mappe)

Do Until Mappe = ""
DatVgl = FileDateTime(s & "\" & Mappe)
If DatVgl Dat Then
Dat = DatVgl
ZMappe = s & "\" & Mappe
End If
Mappe = Dir()
Loop

Workbooks.Open Filename:=ZMappe

End Sub





--

Dave Peterson