Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am opening an existing spreadsheet and appending rows from a SQL Db. The
rows are being appended correctly where I want them to be, ex. starting at N15. However, the existing content, from A1:M519, is being wiped out. The data I am adding will always be placed at the end of the existing content. Any ideas on how to keep the existing stuff from being wiped out? Thanks in advance. Regards. -- Kevin C. Brown Developer The Darby Group |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How about showing your code?
It's difficult to suppose that Excel is deciding on its own to remove the existing data, so the obvious suggestion on how to avoid this is to change your code, but not having seen it it's not possible to be any more explicit... Tim "KevinB" wrote in message ... I am opening an existing spreadsheet and appending rows from a SQL Db. The rows are being appended correctly where I want them to be, ex. starting at N15. However, the existing content, from A1:M519, is being wiped out. The data I am adding will always be placed at the end of the existing content. Any ideas on how to keep the existing stuff from being wiped out? Thanks in advance. Regards. -- Kevin C. Brown Developer The Darby Group |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Appending rows from multiple sheets into one | Excel Discussion (Misc queries) | |||
appending one Excel file to another ? | Excel Worksheet Functions | |||
Appending or Concatenating rows by Client | Excel Worksheet Functions | |||
Appending Two or More Excel Sheets | Excel Programming | |||
shared workbook appending/merging rows of data from several worksh | Excel Discussion (Misc queries) |