Thanks

A picture is worth a thousand questions.

My email is jerryf_at_footegroup_dot_com

Thanks again

-----Original Message-----

From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf

Of Jarvis, Matthew

Sent: Tuesday, March 01, 2011 1:11 PM

To: profox@leafe.com

Subject: RE: Copy Excel Row with automation

> -----Original Message-----

> From: profoxtech-bounces@leafe.com

[mailto:profoxtech-bounces@leafe.com]

> On Behalf Of Jerry Foote

> Sent: Tuesday, March 01, 2011 10:56 AM

> To: profoxtech@leafe.com

> Subject: RE: Copy Excel Row with automation

>

> Fred

> I did not make my self clear, I need to insert the copied row into the

> sheet

> so that for a time I have two records with the same data. It looks

like it

> just copy the data to the new row.

> Ideally the record I copy will be inserted before of after the select

> record

> Sorry

> Thanks Jerry

>

Jerry-

I have a PRG that I wrote for a series I did on Office Automation a

number of years ago for VFUG. It doesn't exactly address what you are

doing but it touches on a lot of neat features of automating Excel (and

Word).

It shows Inserting rows and such and some other goodies...

I'd be happy to send it to you (and anyone else) that wants to see it

just for a reference...

Thanks,

Matthew Jarvis || Business Systems Analyst

IT Department

McKenzie-Willamette Medical Center

1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax:

541-744-6145

--------------------------------------------------------------------------

Disclaimer: This electronic message may contain information that is

Proprietary, Confidential, or legally privileged or protected. It

is intended only for the use of the individual(s) and entity named

in the message. If you are not an intended recipient of this

message, please notify the sender immediately and delete the

material from your computer. Do not deliver, distribute or copy

this message and do not disclose its contents or take any action in

reliance on the information it contains.

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/EACCE77342984132BE8F171783A45C8B@jerryfootePC

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.