velohead
Board Regular
- Joined
- Aug 22, 2007
- Messages
- 222
- Office Version
- 365
I’m using Excel 2013
When I go to Data, Connections, Edit Links, and the “Edit Links” window pops up, I can see near the bottom left the “Location” of the file(s).
Well, almost see, because when the pathname is long, (as it is in each corporate that I have worked for, over the decades), then one can only see part of the pathname.
Is there a way for me to see the full pathname, as the first part is always the same, but obviously,
the second part is the more important, eg when rolling files from month “X” directory, to month “Y” directory.
Most pop ups can be resized, not this one.
I would have thought MS would have fixed this problem many years ago.
A VB solution would be acceptable.
When I go to Data, Connections, Edit Links, and the “Edit Links” window pops up, I can see near the bottom left the “Location” of the file(s).
Well, almost see, because when the pathname is long, (as it is in each corporate that I have worked for, over the decades), then one can only see part of the pathname.
Is there a way for me to see the full pathname, as the first part is always the same, but obviously,
the second part is the more important, eg when rolling files from month “X” directory, to month “Y” directory.
Most pop ups can be resized, not this one.
I would have thought MS would have fixed this problem many years ago.
A VB solution would be acceptable.