Thread: How to get the path where a shortcut of an Excel sheet is located
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
barnabel barnabel is offline
external usenet poster
  
Posts: 119
Default How to get the path where a shortcut of an Excel sheet is located
Sorry, I am pretty sure that the OS does the translation of the sortcut and
Excel is passed the real file not the shortcut. So there is no way from
inside Excel to know where the shortcut is.

Peter

"Stefan Mueller" wrote:

If you start an Excel sheet (e.g. Test.xls) you can get the path where
the Excel sheet is located with
MsgBox (ActiveWorkbook.Path)

Now you create a shortcut (e.g. Shortcut of Test.xls) and move it to
another directory. If you start that shortcut
MsgBox (ActiveWorkbook.Path)
still shows the path where the Excel sheet is located.

Does someone know how to get the path where the shortcut is located?

PS: In real VB I do it with a FileListBox: MsgBox (FileListBox1.Path)


Reply With QuoteReply With Quote