Rayne
asked on
COPY from excel to notepad
Hi,
I need a VBA to copy an open a HUGE workbook and copy all the cells of worksheet1 (column A-ZZ) into a notepad.
So,
1. Open a notepad
2. Open a workbook – copy the worksheet1 currentrgion onto clipboard
3. Paste into opended notepad using clipboard memory
How do I do that in vba?
Thank you
I need a VBA to copy an open a HUGE workbook and copy all the cells of worksheet1 (column A-ZZ) into a notepad.
So,
1. Open a notepad
2. Open a workbook – copy the worksheet1 currentrgion onto clipboard
3. Paste into opended notepad using clipboard memory
How do I do that in vba?
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
ASKER
Thank you for your help so far....I had to use print to avoid the double qutoes