Paste cell content to another program

[Frank]

Hi,
I want to write a routine to copy a cell content from Excel and paste it at
the current cursor position of another opened program, say Note Pad. Can
someone help please.
Thanks in advanced.
Frank Chan

 

[Guest]

Frank:

Two things. First, if you really want to get to Notepad, you're in for
a lot of work as Notepad is not conversant with MS Office (that is, you can't
get to the VBA behind it, if it uses VBA at all). Second, if you want to
pull this off using MS Word, then you have to use Word references in Excel
(in the VB editor, click Tooks, References) and then write Excel/Word code in
your Excel program. This is the fundamental premis behind being a MS Office
Integrator (programmer). It's not really hard but you'll have to know how to
code VBA behind Word as well as Excel.

Steve in Ohio