how to specify user profile desktop path in excel vba
hi,
I have the below code which is working good on my computer.
Now if i have to share with the file with some other user who have a different name it is not working because of userprofile.
so, how to modify the below macro so that it should work on different user profile also.
the above code is not working if i am replacing c:\users\kishore with %userprofile%
Please Login or Register to view this content.
please help;
Last edited by kishoremcp; 07-23-2013 at 03:44 AM.
Please Login or Register to view this content.
I have used the following code in a couple of my projects to identify the path for a user's desktop folder (can't remember where I found it, but I certainly can't claim it as my own):
You can then modify your code as follows:Please Login or Register to view this content.
Kyle123's post crossed with mine - apologies. Looks like this is the same approach.Please Login or Register to view this content.
Thanks Andrew1011, It worked perfectly..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks