Create a VBA code that creates a shortcut folder on desktop.

[samdegg]

Hello,

I am currently unsure whether this would be possible using VBA. I want to create a simple spreadsheet that learners can open when they first log on our computers, enter their name and username and it will create a shortcut folder on the desktop to their student folder on our server.

The server is 2008 but for the amount of learners we have and the turnaround it would not be worth creating everyone user accounts.

The other thing I would like it to do is when Excel is closed or the computer is logged off, the folder gets deleted from the desktop.

The problem is that other learners are saving there work in other peoples folders or deleting other peoples work. I have looked at folder management software and can not find one that will suit my needs, hence why I thought about Excel and creating something that suits our needs.

Regards

Sam

[Kyle123]

Can't you do this as part of their log on script?

[samdegg]

I am unsure because all the computers use a "learner" log on. They do not have there own usernames or anything, that's why I thought this might be an option. Then they can not access other peoples folders.

[Kyle123]

How would you prevent them from accessing other learners' folders?

[samdegg]

When the shortcut is create, it will be to their folder and their folder only. If they know what they are doing, they might be able to access the others, but most of them won't know how.