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

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,114,084
Messages
5,545,867
Members
410,711
Latest member
Josh324
Top