View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KentAE[_2_] KentAE[_2_] is offline
external usenet poster
 
Posts: 6
Default "Dir" uot of order

Hi
I run Excel 2007 but are writing code in an 2003excelfile (xls). Suddenly
does not Dir function works in folliwing sub

Sub FindData()

Dim path, filename As String


path = "D:Officebyggaren\CBRE\TEMP\"

Application.ScreenUpdating = False
filename = Dir(path)

......and so on

The path D:Officebyggaren\CBRE\TEMP\ include three files.
Dir have worked but suddenly it doesn't!!! Runing step by step I can see
"Filename ="" ".
Thank's in advance to that guy who can support me
/KentAE
--
If you are old enough, you have your future behind you.