Change GetOpenFilename Default Location

Originally Posted by shg

Please Login or Register  to view this content.

Ok, so i'd change with the changeDir, or ChDrive, but since everyones desktop has a different path naturally, is there a windows call that specifies the user desktop that would auto propagate the proper path?

Originally Posted by shg

I don't understand your question, but if you want to change to a UNC path, perhaps http://www.mrexcel.com/forum/showthread.php?t=4035

I tried this, but it kept saying, "could not connect to /desktop

Let me try to explain a little more detailed.

When Calling the GetOpenFilename() method, the popup box for me at least ALWAYS defaults to the My Documents location
My Documents location: \\dtcdat-txwl001\nwtx7965\My Documents\
I want it to default to the users Desktop location
My Desktop location: C:\Documents and Settings\nwtx7965\Desktop\

I cannot set the path to C:\Documents and Settings\nwtx7965\Desktop because other users cannot access my desktop so the nwtx7965 changes for each user. I apologize but I'm not used to calling API functions and they aren't working for me the way I thought they would, perhaps its me that is making the problem with the example you said. I tried to search information on the API and still couldn't find the solution. Perhaps I've asked for the impossible, but if anything, I've come to discover you can do just about anything you want in Excel.

Originally Posted by shg

So does it work for the one particular user if you do

Please Login or Register  to view this content.

Yes it works for me if I do that, but not for any other user on their own pc's due to the location having a different nwtxid, based off of their username.

Originally Posted by shg

Do you have a list someplace?

No, and it would be impractical as well. There are over 500 employeees this could be released too, over 11 different centers. Others have naming conventions different than my center, and every persons desktop is different, even my desktop at home is different as the nwtx would be replaced with Tirren, and the C:/ would be replaced with G:/ (don't ask, it wouldn't let me choose C for my main directory for some reason).

I cannot, the My documents, is a roaming profile, desktop is local only.

Hello Tirren,

This macro uses the Windows API to display the system Open or Save dialog. It will open the directory you specify. This will work with Excel on Windows '95 up to '2003. It is untested on Excel 2007. Please do not attempt to change any part of this macro, unless you know exactly what you are doing. Load this into a standard VBA module.

Please Login or Register  to view this content.

Example

Please Login or Register  to view this content.

Sincerely,
Leith Ross