View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Walden2 Walden2 is offline
external usenet poster
 
Posts: 7
Default VBA to open a shortcut to a workbook

Is there a way to use VBA to "open" shortcuts to workbooks?

For example,
Book1.xls is in Folder A
There is a "shortcut" to Book1.xls in Folder B
Book2.xls is a workbook in Folder B
When opening Book2.xls, what VBA would look for shortcuts in the
Folder B and open those files?

Thanks,
Walden