Identifying XLS Workbook

[BigEye64]

Hi I was wondering how if I could write a VBA code to find a WorkBook in a shared folder that only has a partial naming convention (IE the first few and last few characters change but the middle few are always constant). Once I have identified the the Workbooks I also need to identify the most recent.


The Project I am attempting is for work I need to print several work sheets out 3 or 4 times a day and the people creating them all have their own naming conventions. I would like to automate this printing process so as Excel 2000 finds & prints them when I click a button with out me having to go looking for them.


Any help greatly appreciated.

[mrice]

How about something based upon this stub macro

Please Login or Register  to view this content.

[BigEye64]

Very helpfull thankyou but how do I select the most recent file and print it.

[mrice]

Try

Please Login or Register  to view this content.

[BigEye64]

Whow man thank you so much you are a legend. That piece of code has just made my working day so much easier.