Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
People,
I am working on a process which does the following. Each day 1) Downloads an xls File from an FTP server. 2) Reads it. 3) saves information in database if applies. Every thing works excelent on my laptop and on my desktop. But when moving to the server where this will be runing, I encountered that the the excel was prompting a conflict name dialog, expecting a new value to replace a range that has the same name as another one. It is tru that the file has ranges with same name, but that is in the feed, it something I can't change unless i find out how to edit the binary. But this it is not displaying it on my 2 test environments. This is NOT the prboblem where pasting a sheet or values prompts for do replace or what ever, here it asks for a new name and can't go on. I am working with c# and using the interop .dll I have hooked from the onOpen event and found the way to replace these names but the Message box appears before raising the event. I have already set ExcelApp.DisplayAlerts = false; but this is not the same case as much that I have read about. Is there any setting in excel that runs that check on opening? The differences are that the computer that displays the name conflict window has excel in spanish and loads the eurotools.xla on start. Please I need this very urgent. Thanks. i wish I could send the file or a snapshot of the message box. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Name Conflict window pops up, when I try to open a saved worksheet | Excel Discussion (Misc queries) | |||
Conflict with valid range reference error | Excel Discussion (Misc queries) | |||
Different usage of range formats, conflict? | Excel Programming | |||
Name Range & Macro conflict | Excel Discussion (Misc queries) | |||
Name conflict | Excel Programming |