SebastianHuang
New Member
- Joined
- Dec 5, 2019
- Messages
- 38
- Office Version
- 2013
- Platform
- Windows
I want to create a new excel file with the name coming from the clipboard and save it in Saved folder on desktop.
E.g., I copied a text called 2020 Highest mountain. Instead of doing save as, paste name, and choosing to save as excel book, and save it in the saved folder. Is there a vba that can do that.
The names will be different every time as it is coming from clipboard.
Maybe let me review the file so I could close it myself. or have the excel program close it for me.
That would be all.
E.g., I copied a text called 2020 Highest mountain. Instead of doing save as, paste name, and choosing to save as excel book, and save it in the saved folder. Is there a vba that can do that.
The names will be different every time as it is coming from clipboard.
Maybe let me review the file so I could close it myself. or have the excel program close it for me.
That would be all.