Create Shoertcut and Icon?

[ksmith]

Hello all. I have created an Excel application which will be emailed to various users. When they click a button it automatically creates folders on their "C" drive and then saves the workbook.

Is there a way to also have it create the shortcut to the desktop. Then is there a way to assign a different icon to the shortcut via VBA?

Just trying to make this as user friendly as possible.

Thanks!
Kyle

 

[Glaswegian]

Kyle

Here's an old thread on this subject - may help.
http://www.mrexcel.com/archive2/49000/56968.htm

Regards

 

[ksmith]

perfect!

Thanks!