jamesurwin
New Member
- Joined
- Feb 5, 2008
- Messages
- 5
Hi,
I'm trying to write a macro that does the following:
1. Copy a range of cells from excel
2. Open Notepad
3. Paste, Select All and Copy
4. Return to excel worksheet and paste
5. Close Notepad
Could anyone advise me how you go about coding for closing Notepad please ?!?!?! I dont need to save .txt file once I've pasted back into excel.
Many thanks,
J
I'm trying to write a macro that does the following:
1. Copy a range of cells from excel
2. Open Notepad
3. Paste, Select All and Copy
4. Return to excel worksheet and paste
5. Close Notepad
Could anyone advise me how you go about coding for closing Notepad please ?!?!?! I dont need to save .txt file once I've pasted back into excel.
Many thanks,
J