Macros that write data to a new spreadsheet?
Is there a keystrokes type of macro format? What I mean is that it would be
nice to build in Excel tips into a macro since I carry around my Excel.xlb
and personal.xls (and book.xlt). If there was a "write text to spreadsheet"
type of macro code, I could write tips in. Then I could create a menu
called XLtips or something and have all those tips macros accessible from
there that would write to an empty spreadsheet from which I could simply
copy/paste the code from.
This is what comes to mind as a nifty, if unorthodox solution, simply
because all the macros and buttons are built-in.
Is this possible? (Or perhaps someone has a better, but also easily
portable solution already but that doesn't require an add-in?) If it is
possible, though, are there any examples of coding around anywhere?
Thanks.
|