Opening workbooks via shortcuts

[Sir Babydum GBE]

Ola!

How does one get a macro to include shortcuts to workbooks in other folders in code where its being asked to open workbooks in a given folder?

Thanks

BD

[rory]

You would need to look for .lnk files too then use Workbooks.Open on those.

[mdmackillop]

Have you considered using hyperlinks?
[VBA]Sub sbd()
ActiveWorkbook.FollowHyperlink "C:\AAA\Test.xls"
End Sub
[/VBA]