Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the path where a shortcut of an Excel sheet is located
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the path where a shortcut of an Excel sheet is located
Hmm, but how can the VB's FileListBox do it?
Actually, the VB FileListBox doesn't show the path where the shortcut is located, it shows the path entered in 'Start in:' of the shortcut. Do you think I can somehow get this information within Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard shortcut to flick from sheet to sheet in Excel? | Excel Discussion (Misc queries) | |||
Can the source in data validataion be located in another sheet? | Excel Discussion (Misc queries) | |||
Extract Target path from a shortcut | Excel Programming | |||
make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
How to find the path where a .XLA is located | Excel Programming |