Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting rows in sheet from custom application and keeping internal links
I have the following problem:
I want to create an excel workbook with data coming from a database. This done using VB.NET or any other programming language. The first time the workbook is created there is no problem. Later on I want to manually add sheets and use the data in the automatically generated sheets. Still no problem so far... I wonder wether it is possible to later on insert rows in the autamically generated sheet, and not loose the links I made from the manually generated sheets to the data in the automatically generated sheets. This adding of new rows is also done by the program that makes the workbook, so not from within excel. For instance I have a sheet called input which is generated when the workbook is first created. Cell A1 and A2 contain values that are used in a manually created sheet (this sheet is created when using the excel application). Now I want to insert a value between cell A1 and A2, making A2 - A3 (with my own program). But I don't want to loose the link/reference to this value, now in A3, in the manually generated sheet. Is this possible or will the references always be lost because I don't make use of the excel application to insert the new row? Thanks, Sam Gerene |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting rows while keeping cell contents the same | Excel Discussion (Misc queries) | |||
inserting rows keeping the merged cells | Excel Discussion (Misc queries) | |||
Links after inserting rows | Excel Discussion (Misc queries) | |||
Excel links & inserting/deleting rows | Excel Discussion (Misc queries) | |||
Using Links & inserting rows into Excel - help? | New Users to Excel |