Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Robert Crandal wrote:
"Auric__" wrote : While you usually *can* find it using the already-suggested USERPROFILE environment variable, or the FileSystemObject, the method I've found to be "best" (most reliable, whatever) is the SHGetSpecialFolderPath API call: ........ (I use this because I usually change the location of the desktop to a certain directory on my server. Good luck getting something in C:\users\Auric\Desktop to show up on my desktop.) First, thank you everyone who replied. All info was helpful..... And, BTW Auric, each user is assigned a directory on the server. I believe that each user has a Desktop either on the C: drive or a server directory named \\fserver1 or something similar. I don't remember exactly, but I will have to check. I will give this SHGetSpecialFolderPath() API next time I go to work. Seems odd that USERPROFILE and FileSystemObject and SHGetSpecialFolderPath() would return different results, but I shall put this to the test. Thanks again. I tested SHGetSpecialFolderPath and it worked great pointing to right folder. I have desktops redirected to another disk separately from userprofile and it returned correct folder. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Desktop path? | Excel Programming | |||
Remove end folder from path found with ThisWorkbook.Path command ? | Excel Programming | |||
EXCEL FILES SAVED TO DESKTOP WILL NOT OPEN FROM DESKTOP | Excel Discussion (Misc queries) | |||
How to path to user's desktop | Excel Programming | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) |