Macro to save file on any user's folder on the desktop
Hello Excel Forum
I want to save a workbook to a folder name "QWERTY" on any user's desktop.
- Can someone please help me with a macro which would create a folder named "QWERTY" on any user's desktop and not just mine.
- Save the Excel workbook with a name based on a cell reference in that workbook.
- Save the workbook in the "QWERTY" folder created above.
I would appreciate if anyone could teach me how to get the above problem solved.
the following code will give you the path to any user's desktop.
With this path, you can create any folder you want.
I found it in Reddit:
Please Login or Register to view this content.
https://www.reddit.com/r/excel/comme...sktop_via_vba/
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
Hello,
Please Login or Register to view this content.
Kind regards, Harry.
Something to start with.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
@Pierre - Thanks for the link.
@Harry - That worked like a charm. You rock bro
@bakerman2 - That was an excellent solution. Thanks bro
I appreciate the support showered by all 3 of you. Keep rocking.
Glad to help and thanks for rep+.
It's a start, but definitely not a finish.
Run the code twice.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks