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

B

Belinda

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 How to create individual shortcut for each user 1
Desktop shortcut 0
Make shortcut to Excelfile on desktop 4
Code Only Works on Certain Sheets Within a Workbook 2
Macro for all Excel Workbooks to print to PDF 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Import multiple workbooks to current workbook in specified row number 0
Distribute an excel workbook shortcut 1

Top