I want to distribute a workbook to multiple users.
A macro identifies the NT username, searches a second file to generate a userform that lists the reports the user has access to (then closes 2nd file), accesses, extracts and copies data from other source files required to generate the reports indicated by the users selection.
I anticipate that there may be problems in putting this application on a fileshare because several users might want to access the same source files at the same time which might lead to contention.
Would this application work better on the web?
Any tips would be appreciated.