Hello All,
I have a worksheet that I have been using for some time and its been working really well. One tweak I would like to make is to allow my code to save to any users desktop.
Here is the code for my save button where I save the file and add the date to it. I would like to LEARN how to do this more than just have someone spit out the code...(or explain how it works?)
Please Login or Register to view this content.
Hello zerodegreec,
You can return the desktop path for the logged on user easily using the Windows Script Host. This is one of several Scripting languages used by Windows that are accessible from VBA. Copy this macro into a separate VBA module.
I have incorporated the macro into your code...Please Login or Register to view this content.
Here is a complete list of the special folders that are available:Please Login or Register to view this content.
AllUsersDesktop
AllUsersStartMenu
AllUsersPrograms
AllUsersStartup
Desktop
Favorites
Fonts
MyDocuments
NetHood
PrintHood
Programs
Recent
SendTo
StartMenu
Startup
Templates
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello zerodegreec,
Please take more care with your Thread Titles. The Forum Rules ask you not to use unnecessary words like VBA in your question titles
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks