Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
General Names and Links question
I am having a series of recurring problems, so I think I need to read
something and I hope someone can point me to a good resource. I have made a macro that copies various "template" sheets from one workbook to another. I have a bunch of "presentation" sheets that are nicely formatted and "data" sheets that have all of the calculations. The "presentation" sheets refer to cells and names in the data sheets. And the data sheets refer to a named range that exists in the new workbook. All of the copying works just fine, but I am having problems with both links and names. Sometimes, but I can't figure out when, the copied presentation sheet refers not to the copied data sheet, but to the old data sheet in the presentation workbook. And sometimes, but I don't see the pattern, the data sheets do not refer to the named range in the new workbook, but refer to some (non-existent) named range on the sheet itself. When I hand delete that name, the sheet works, but when I programmatically delete it the whole process gets messed up. I am asking for a solution to this problem (which is probably not well enough described, but I did the best I can), what I would like is something that gives me a solid understanding of how Excel handles these things, when links and names update, when they don't, how it works, etc. TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
General Names and Links question
Use the debug options in the visual basic editor to step through the code and
add break points. Use the mouse (or watch windows) to isolate the problems. " wrote: I am having a series of recurring problems, so I think I need to read something and I hope someone can point me to a good resource. I have made a macro that copies various "template" sheets from one workbook to another. I have a bunch of "presentation" sheets that are nicely formatted and "data" sheets that have all of the calculations. The "presentation" sheets refer to cells and names in the data sheets. And the data sheets refer to a named range that exists in the new workbook. All of the copying works just fine, but I am having problems with both links and names. Sometimes, but I can't figure out when, the copied presentation sheet refers not to the copied data sheet, but to the old data sheet in the presentation workbook. And sometimes, but I don't see the pattern, the data sheets do not refer to the named range in the new workbook, but refer to some (non-existent) named range on the sheet itself. When I hand delete that name, the sheet works, but when I programmatically delete it the whole process gets messed up. I am asking for a solution to this problem (which is probably not well enough described, but I did the best I can), what I would like is something that gives me a solid understanding of how Excel handles these things, when links and names update, when they don't, how it works, etc. TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
General Names and Links question
On Feb 15, 11:21 am, Joel wrote:
Use the debug options in the visual basic editor to step through the code and add break points. Use the mouse (or watch windows) to isolate the problems. Thanks, but that doesn't help in this case. I am trying to understand how names and links work during copying. Sometimes they seem to go with the destination, but sometimes not. And, yes, I do know that I am asked what I want to do, but the results don't make sense to me. I am sure that there is some factor I am missing here. I can "fix" an instance by deleting a "local" name, but that does not help all that much for an automated system. I want to have it right in the first place, not clean it up individually later. " wrote: I am having a series of recurring problems, so I think I need to read something and I hope someone can point me to a good resource. I have made a macro that copies various "template" sheets from one workbook to another. I have a bunch of "presentation" sheets that are nicely formatted and "data" sheets that have all of the calculations. The "presentation" sheets refer to cells and names in the data sheets. And the data sheets refer to a named range that exists in the new workbook. All of the copying works just fine, but I am having problems with both links and names. Sometimes, but I can't figure out when, the copied presentation sheet refers not to the copied data sheet, but to the old data sheet in the presentation workbook. And sometimes, but I don't see the pattern, the data sheets do not refer to the named range in the new workbook, but refer to some (non-existent) named range on the sheet itself. When I hand delete that name, the sheet works, but when I programmatically delete it the whole process gets messed up. I am asking for a solution to this problem (which is probably not well enough described, but I did the best I can), what I would like is something that gives me a solid understanding of how Excel handles these things, when links and names update, when they don't, how it works, etc. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A VERY General question | Excel Worksheet Functions | |||
General Question | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
General purpose "open links" macro | Links and Linking in Excel | |||
General question | Excel Programming |