Exporting a data set into an excel sheet without deleting the rows of data in that sheet.

[aperansi]

I have data set that I am currently exporting into an excel sheet. Moving forward, I would like to continue to export into that same sheet without deleting the data currently in that sheet.

The reason I would like to do this is because I am currently running the data for a large timeframe which causes the program to run for an extended period of time. If i was to shorten the timeframe to the latest month, and simply add the latest months data into the existing sheet, this would make things go much faster.

Is there a way to do that within my program? Thank you for your help.

[Reeza]

Not easily I'm afraid. It's easier to redo the full workbook IMO. I actually can't even think of any way at the moment.

[aperansi]

Can you tell me what you mean by redo the full workbook? What are some ideas you have? Im not sure how I would really go about this.

[Reeza]

Pretty much what you’re doing now. Any incremental load would use a different tool, DDE or VBS in my experience and then you increase the chance of issues.

[aperansi]

Thank you Reeza