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) |
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 |