VBA create a desktop shorcut this xlwbook

tony.reynolds

Board Regular
Joined
Jul 8, 2010
Messages
97
Can Excel make a desktop shortcut to the current workbook in VBA?

I have a macro that runs when a user opens a new version of my workbook and imports their data then saves it as a new name they chose

i would love it to also create a shortcut on the desktop or even better in the start menu!

is this poss?
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,314
Members
409,862
Latest member
lbisacca
Top