PDA

View Full Version : [SOLVED] Create a Desktop Shortcut for New Folder



DragonWood
11-05-2011, 02:46 PM
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.

Trebor76
11-05-2011, 05:23 PM
For reference - this has been cross-posted (and potentially solved) here (http://www.mrexcel.com/forum/showthread.php?p=2920188#post2920188)

DragonWood
11-06-2011, 09:10 AM
See my reply on the Mr. Excel board.