Script for excel (Sunny)

HCL Domino Domino Forum
1

Hi, I’m working with a lotus script agent that export data from a notes view to a csv file that opens automatically in an excel file. After finishing extracting the data I want to clear out the last two rows of the excel file, but I don’t know the command for that, I do know the command to assign a value a certain cell on the excel file.

Thanks

Sunny

2

Subject: Record the excel macro

Use the excel record macro commands to create a macro that selects and deletes the rows you wantCopy that (with a bit of tweaking) into the Lotusscript