Hello,
I have not had formal training in VBA and am learning as the need arises.
I have a requirement for an Excel VBA procedure to create desktop shortcut to excel file named after the username e.g. Joe Bloggs.
I am thinking something like this: I will have a list of login users ids and full names in a hidden sheet in a workbook. I can e-mail this workbook to selected users. The user will open the workbook and press a button to create the shortcut My procedure will need to extract the login user id. Using the extracted login id, read the corresponding record from the list in my sheet to get the full 'user name'. Then create a shortcut to the file with the same name as the 'user name' and copy to desktop.
Thank you for any help and advice..
(When I have the above function working, I suppose I could then think about automating the e-mail step as well)
I have not had formal training in VBA and am learning as the need arises.
I have a requirement for an Excel VBA procedure to create desktop shortcut to excel file named after the username e.g. Joe Bloggs.
I am thinking something like this: I will have a list of login users ids and full names in a hidden sheet in a workbook. I can e-mail this workbook to selected users. The user will open the workbook and press a button to create the shortcut My procedure will need to extract the login user id. Using the extracted login id, read the corresponding record from the list in my sheet to get the full 'user name'. Then create a shortcut to the file with the same name as the 'user name' and copy to desktop.
Thank you for any help and advice..
(When I have the above function working, I suppose I could then think about automating the e-mail step as well)