excel macros
Posted by Todd on February 01, 2002 4:57 PM
Will the office clipboard work in a macro? I can't seem to make it happen.
Thx
Todd
Posted by Archimedes on February 01, 2002 9:18 PM
What are you trying to do?
Posted by Todd on February 01, 2002 9:39 PM
Re: What are you trying to do?
Building a mail merge file from blocks of info. Very basic......taking a column here, there, doing basic calc (+-/*) and copying into another workbook. Was taking the office clipboard and copying 12 pieces to it and then going to the merge workbook.....
I had never really used Excel before a few weeks ago, bought a dummy book and just started using it........... gotta start somewhere.....
Thanks
Todd
Posted by Archimedes on February 02, 2002 1:03 AM
Re: What are you trying to do?
The clipboard works the same for macros as for manual copy/pastes.
In your macro, just write the code (or record) for your copy/paste and the clipboard automatically takes care of it. Whether manually or by macro, of course, you have to copy/paste each piece of data "piece" by "piece".
Post again if I've failed to understand your problem.
