Is it not just easier to link your lookup tables into BO so that they are
there at source?

"smw226 via OfficeKB.com" wrote:

Hi Tim,

What I am thinking is....

auto_exec macro on the file which scans a given folder and lists all files on
a hidden tab.

Combo Box driven by this list.

VLookups driven by value of Combo List

That said, could this data be put into access as this would solve all your
issues, allow you to keep an audit log of people's actions and , if
programmed correctly, allow you to easilly restore data if changes are made
in error.

One thing I have learned, the hard way, is you want to give the minimum of
people access to amend your data and, where you do, you want to keep detailed
audit trails of thier actions.

HTH

Simoin

TimN wrote:
That certainly would work. I was trying to come up with a more systematic
way to do it so the group of users who are not too sophisticated, won't have
to go in and manipulate the data files.

TKN

Re-save 'SICK_10_15_06.xls' as 'SICK_Current.xls'.

[quoted text clipped - 41 lines]

Thanks!

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via http://www.officekb.com