View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default document information from folder

I have about 200 workbooks in a folder. I want a macro to create a sheet (or
add information to a worksheet I have open) that lists the filenames in the
folder, as well as the date created, last date modified, the value in cell
"A1" and the number of times the value in column A begins with "2" and the
number of times it begins with "6". I know how to do some of those things
but not all of them. Any help is appreciated.