Massive Excel Challenge- Is it doable?

[greekboyuk]

Hi,

Before I start a massive project I would like to consult you all, excel gurus and users whether the task is achievable or not just using excel with the only possible addition of using access if necessary.

Software to be used:

Excel 03
Access 03 - only if helps to load the data

The task:

1. Enable users to book courses, using userforms and submit the request to a input database within the same workbook or another workbook, whichever is more practical.

2. Identify usernames using the

Please Login or Register  to view this content.

or any other procedure to restrict users, depending their username to access specific sheets of the workbook. Also depending the above to pre-load pre defined userforms in specific sheets so when users are navigating though the menu to go to that location.

3. Share the massive workbook and allow all users to access it simultaneously (Even if I had to create hundred of worksheets to assign each user with one I could proceed).

5. Allow local network shared videos to be played within the excel embed WMPlayer from multiple user. For instance if user a plays video 1 and user b plays the same video to allow this action without having to duplicate videos to different locations.

6. Count the amount of times that specific buttons or/and shapes are click and update the results to the databases.

7. Create a timesheet entry where, depending on user permissions (step 2) to share a single sheet within the workbook and define a range for each user so when the go to that sheet they can only see their range (if I had to create separate sheets I am happy to proceed).

8. Disable all format function, ribbon, status bars etc for all users. They should be able to input data, play videos and submit data.

9. Add this spreadsheet in the vba trusted sources so the user would never had to choose to enable content or not. ( alternatively prevent user to open workbook unless they enable macros).

The tricky bit in my personal opinion (not that my knowledge is to great) is that when sharing same workbook with appox 600 people it may crash a lot or am I wrong?

I know it is a lot, however I have seen posts and some examples in this forum that have blown my mind away.

Could you please advice me to whether I can do all this or I should be looking a different application approach and if so what do you recommend? I posted this thread to the Programming section as if that is achievable vba is required, if I am wrong I do apologise and would ask nicely the OP to move the thread as appropriately.

Many Thanks
greekboyuk

[nimrod]

Wrong tool for the job. Get a Grails expert and have it up and running in a couple of hours.

[greekboyuk]

Hi nimrod,

Thank u for your advice. My company won't invest in developers at this climate that's why this project need to be accomplished with tools such excel, access, infopath and applying vba to create the solution. I guess I will wait for more responses from other users.

Many thanks