471,356 Members | 1,804 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,356 software developers and data experts.

Excel 2002 FR/ENG

JS
Here is something weird that is happening to me and I just cannot seem to fix
this problem:

I have built an application that does a data dump into Excel and then
creates named ranges so that the user can easily link to the data.

I am using the latest PIAs for Office (v.10.0) and everything works fine
when I am running the application using an English version of Excel.

When I am running with the French version of Excel I just cannot add a
ranged name in Excel. The application does not crash but it simply removes
the named range from Excel and does nothing...

Here is the code I use in order to add the ranged name that works in ENG
Excel 2002:

public void AddName( string Name, int iRowStart, int iColStart, int iRowEnd,
int iColEnd, Microsoft.Office.Interop.Excel.Worksheet sht, Workbook wbk )
{
string addr = "=" + sht.Name + "!R" + iRowStart.ToString() + "C" +
iColStart.ToString() + ":R" + iRowEnd.ToString() + "C" + iColEnd.ToString();

wbk.Names.Add( "__" + Name, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, addr, Type.Missing );

}

Thanks,

JS

Jul 21 '05 #1
0 1012

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Yakimo | last post: by
3 posts views Thread by Boris Condarco | last post: by
7 posts views Thread by postings | last post: by
22 posts views Thread by Howard Kaikow | last post: by
3 posts views Thread by Ian Dunn | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.