Guys,

I need a file that will launch a chosen Excel file. I will be using this on our citrix farm.

I have a workbook with 2 columns. Column A contains the Project Name, Column B contains the path for that projects workbook.

So, I need a small app that will give a list of project names, then when chosen and OK clicked, it will pass the relevant path to Excel and open it. Thats the easy bit, I think !

I also need it to detect if the file is already open, and then disallow the read-only prompt. (This doesn't show in Citrix anyway for some reason, so the users are working on it concurrently.) So if the file is already open, show a message "This file is in use by UserName (from Excel)" Then it closes when OK is clicked. Only one user should have this file open at any one time.

Could anybody give me a starter for 10 ?

Cheers
Bob