Thread: dir
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default dir

Using a = Dir a asks for a second file with the same name. For
subsequent files, use a = Dir.


In article ,
"seeker53" wrote:

I have specified a directory path and a variable is populated for the first
file. When I try to get the next file in the directory by useing a = Dir a
is populated with "". This would indicate that all files have been seen but
there are 8 more files in the directory that have not been touched. Why
would dir give a ""?

seeker53