ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Range Name Conflict ON OPEN (https://www.excelbanter.com/excel-programming/384484-range-name-conflict-open.html)

[email protected]

Range Name Conflict ON OPEN
 
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.



All times are GMT +1. The time now is 03:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com