View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 6
Default Count File Names

Hi All,

I having an issue with version control on Buisness cases. I currently
have a spreadsheet that looks into a folder and picks up details from
a number of files. However, they require version control numbers so
there will eventually be multiple files say 2010-01 v1.0, 2010-01
v1.1. Is there a way I can:

1) Get a macro to count the number of 2010-01 files there are in the
folder, and
2) Get my version control sheet to look at the latest version of the
file (in this example: 2010-01 v1.1)

Cheers,

Chris