How to install a workbook as a shortcut on the desktop programmatically
 

Hi All

I have developed a workbook which is like a Excel dashboard and I want
to send out this workbook to be saved on every user Desktop locally or
saved as a shortcut on the desktop. I want to implement it in a form
so that when the user double clicks the attachment it must save the
workbook in some predetermined location and create a shortcut to the
same on the users Windows desktop. Can you please let me know how I
can implement this kind of self installing workbook. Please provide me
with a sample script to implement the same.

Many thanks
Belinda

How to install a workbook as a shortcut on the desktop programmatically
 

Belinda,

Take a look at this site:
http://vbnet.mvps.org/index.html?cod...esktoplink.htm

Rob


"Belinda" wrote in message
om...
Hi All

I have developed a workbook which is like a Excel dashboard and I want
to send out this workbook to be saved on every user Desktop locally or
saved as a shortcut on the desktop. I want to implement it in a form
so that when the user double clicks the attachment it must save the
workbook in some predetermined location and create a shortcut to the
same on the users Windows desktop. Can you please let me know how I
can implement this kind of self installing workbook. Please provide me
with a sample script to implement the same.

Many thanks
Belinda