Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Name Conflict window pops up, when I try to open a saved worksheet wkmooreh Excel Discussion (Misc queries) 0 December 17th 09 02:09 PM
Conflict with valid range reference error smaruzzi Excel Discussion (Misc queries) 1 March 14th 07 10:05 PM
Different usage of range formats, conflict? azzura Excel Programming 2 August 14th 06 03:49 AM
Name Range & Macro conflict John Excel Discussion (Misc queries) 3 July 3rd 06 06:07 PM
Name conflict John Turton Excel Programming 2 August 28th 03 04:47 PM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"