Create a Desktop Shortcut for New Folder
Ok, I have a VBA code that uses input boxes to ask the user for three names. It then uses one of the names to make a folder (if it doesn’t already exist). It uses another of the names to make another folder inside the first folder (if that folder doesn’t already exist). Finally, it uses the third name to make another folder (which wouldn’t exist before this) and uses a SaveAs to put a new copy of the workbook in that folder, also using the third name.
This works wonderfully, however, I would like to place a shortcut to the Third Folder on the desktop. I would prefer it to use this same macro so it all happens at once rather than counting on the user to do it.
I appreciate any help I can get.
Reply With Quote
