You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@aggi
I want to open a file depending on a person's username (probably using VBA). I made a custom toolbar for my department and want people to be able to click a button on there to open a file specific to them.
I can pull out the username with Application.UserName but not quite sure of the best way to link that to the file I want to open.
I can just have a series of ELSEIFs with each username but that feels a bit sloppy. Any other thoughts?