View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 153
Default Count of workbooks in a directory

I need to get a count of the number of workbooks in a
directory I specify.

I see an example someone else used (after a ChDir
command):

CountA = Application.Workbooks.Count

but this doesn't work and I can't see how the code would
look to count the number of workbooks only in a directory
I specify.

Thanks for your help. I'm new and stupid.

David