see Chip Pearson's
Working With the Windows Clipboard
http://www.cpearson.com/excel/clipboar.htm
=---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"J.E. McGimpsey" wrote in message ...
Yes.
In article ,
abxy wrote:
Before I attempt to get help creating this macro, first i need to know
if it's even possible to create.
I need a macro to do this(in order, of course):
1. Paste text from the clipboard
2.Organize my text into columns (using the text import wizard or the
texttocolumns vba command I heard about)
3.Save the worksheet with a "today's date(mm-dd-yy) + filename" format
to a specific folder on the HD
4. Print
is that possible?