Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Excel OLEObject RowsCopy

2 posts in Objects Last posting was on 2009-02-09 18:28:14.0Z
Jeremy K Posted on 2009-02-09 17:32:17.0Z
Sender: 2147.499067ce.846930886@sybase.com
From: Jeremy K
Newsgroups: sybase.public.powerbuilder.objects
Subject: Excel OLEObject RowsCopy
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <499068a1.215c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Feb 2009 09:32:17 -0800
X-Trace: forums-1-dub 1234200737 10.22.241.41 (9 Feb 2009 09:32:17 -0800)
X-Original-Trace: 9 Feb 2009 09:32:17 -0800, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9810
Article PK: 736940

This is kind of a continuation of my previous topic. I'm
trying to find code that will allow me to copy an excel row
and duplicate it. Basically, I'm inserting data and I don't
know how many rows of data I will be inserting so I need to
insert rows as I go. Thanks for your help.


Jeremy K Posted on 2009-02-09 18:28:14.0Z
Sender: 2147.499067ce.846930886@sybase.com
From: Jeremy K
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Excel OLEObject RowsCopy
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <499075be.2297.1681692777@sybase.com>
References: <499068a1.215c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Feb 2009 10:28:14 -0800
X-Trace: forums-1-dub 1234204094 10.22.241.41 (9 Feb 2009 10:28:14 -0800)
X-Original-Trace: 9 Feb 2009 10:28:14 -0800, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9811
Article PK: 736941

I was able to find the solution to my problem. I created a
macro in excel that inserts a new row of the row I wanted to
be copied. I then ran the following line of code for as
many rows as I needed to insert (InsertRow is the name of my
macro):

ExcelOLE.Run("InsertRow")

> This is kind of a continuation of my previous topic. I'm
> trying to find code that will allow me to copy an excel
> row and duplicate it. Basically, I'm inserting data and I
> don't know how many rows of data I will be inserting so I
> need to insert rows as I go. Thanks for your help.