PDA

View Full Version : Opening workbooks via shortcuts



Sir Babydum GBE
09-17-2007, 09:09 AM
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
09-17-2007, 09:14 AM
You would need to look for .lnk files too then use Workbooks.Open on those.

mdmackillop
09-17-2007, 11:07 AM
Have you considered using hyperlinks?
Sub sbd()
ActiveWorkbook.FollowHyperlink "C:\AAA\Test.xls"
End Sub