Insert (really) a NEW ROW into Excel WKST

[Ziccozzis]

Hi everyone...

I had read some post about it but anyone has the answer that I'm looking for...

My project will have more than 2000 rows and 10 or 15 columns in a worksheet... I know how insert data in specific row/column but that isn't the answer to my problem.

I read the following (http://msdn2.microsoft.com/en-us/library/aa195769(office.11).aspx):

Insert method as it applies to the Range object.
Inserts a cell or a range of cells into the worksheet or macro sheet and shifts other cells away to make space.

expression.Insert(Shift, CopyOrigin)

expression Required. An expression that returns a Range object.

Shift  Optional Variant. Specifies which way to shift the cells. Can be one of the following XlInsertShiftDirection constants: xlShiftToRight or xlShiftDown. If this argument is omitted, Microsoft Excel decides based on the shape of the range.

CopyOrigin  Optional Variant. The copy origin.

I dont know how to select the row to INSERT and SHIFT DOWN the rows.
I want the following:

ORIGINAL                                INSERTING ROW
ROW    DATA     ------->>>     ROW     DATA
745         one                            745          one
746        two                             746          "NEW INSERTED ROW"
747       three                            747         two
748        four                             748         three

I attached a "pic" about it. HELP I had had some headaches jus for this.

[Coamín]

Hi Ziccozzis

I’m very glad you use LabVIEW with ActiveX. This is an example about how insert a new row into an Excel worksheet. Tell me if you have any question.

Best Regards.

Coamín Cruz

AE México

[Ziccozzis]

Hi Coamin...

I Couldn't see your VI because I'm using LV8.0

I've found the answer to INSERT A NEW ROW/COLUMN using only LV. I didn't use a macro from XL... I only use LV ActiveX.

I think it will be useful to everyone...

But... Coamin, I would like see your code. It can open my mind to new ideas.

Best regards.

"Change ROWS to COLUMNS to add a new COLUMN"

[Coamín]

Hi Ziccozzis

Great news!! 

This is the VI in version 8.0.

Have a nice day.

Coamín Cruz

AE México