PDA

View Full Version : Launching .lnk and url's from excel buttons



GeoSoft
12-05-2006, 02:09 PM
I made buttons for my applications (.bat, .exe etc...) but with some MS apps that only have a .lnk file. I cannot place the short cut (.lnk) and get it to launch. Can someone please enlighten me?

mdmackillop
12-05-2006, 03:54 PM
Hi GeoSoft
Welcome to VBAX
Have you tried FollowHyperlinks method?


ActiveWorkbook.FollowHyperlink "C:\AAA\MyNames.txt.lnk"

GeoSoft
12-06-2006, 07:19 AM
Hi GeoSoft
Welcome to VBAX
Have you tried FollowHyperlinks method?


ActiveWorkbook.FollowHyperlink "C:\AAA\MyNames.txt.lnk"

GeoSoft
12-06-2006, 07:21 AM
This worked perfectly for both the .lnk and url.

Thanks:bow: