Could anyone let me know how to write a few lines to save a selected range to blah.scr on desktop. The range is A1:A12 on worksheet "DATA_1". I have other worksheets on this file but my files are exported into that sheet. Also is there a way to overwrite the file each time anyone press the generate button? Since I intend to copy this file to other computers, could the saveas file be generic and not specific to my computer but definitely lands on anyone's desktop?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Save cell range as .scr on desktop
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,794
- Office Version
- 365
- Platform
- Windows
Duplicate, re-posted here: https://www.mrexcel.com/forum/excel-questions/1112643-save-selected-range-script.html
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules). If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.
Since the other post is more detailed, I am locking this one and leaving the newer one.
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules). If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.
Since the other post is more detailed, I am locking this one and leaving the newer one.
Upvote
0
- Status
Similar threads
- Solved
- Question
