Append values in exsisting excel sheet

HCL Domino Domino Forum
1

I have a problem to append values into an excel sheet.Like I have values of some documents in the excel sheet. i don’t know the statement how to append values to exsiting excel sheet.

                 thanks.
2

Subject: append values in exsisting excel sheet

Assuming that Range is a variant variable that references a cell in your workbook, you simply set the value property

Range.Value = “Added some text”

Range.Value = DateSerial(2007, 12, 31)

Or do you mean appending values to a cell that already contains some other value?

If so, you may have two alternatives:

Range.Value = Range.Value & “,” & “some more text on the same line”

or

Range.Value = Range.Value & Chr(10) & “Multi-line text within a cell”

3

Subject: append values in exsisting excel sheet

The thing is i have a 100 documents in a view i need to export to excel i already exported 50 documents now when i try to export in excel sheet for remaining 50 documents they are Replacing with the previous documents. How to update remaining 50 documents for existing one.

Thanks.

4

Subject: RE: append values in exsisting excel sheet

I assume that somewhere in your code you are setting the starting row. I would just increment the starting row by 50, if this is an agent that will be run once only, and let it go. If this is a regular occurrence, then set up a loop that goes from the starting row and loops while Range.Value <> “” (choose a column you know will always contain a value). When you exit this loop, you know you have either found the first blank row (good) or you have hit a Notes or Excel limit (bad).