I think it depends on how you are rolling out your app. If you have your somewhat inexperienced people doing the installs manually, then you may have to depend on them knowing enough to select the proper drive during the setup. Otherwise, if you are using something like SMS or another deployment tool, you could have it run your VB script ahead of the setup to map the drive.
This could be a tough one, considering you have such a diverse environment.