Sheet whit & in the name

Dec 7, 2011 at 10:49 AM

In my file, I have two sheet :  "sum" and "C & A".
If I make a hyperlink on the tab "Sum" tab to the "C & A" I get an error opening the file

With the code below, the file opens but I have an invalid reference on the hyperlink

Ws_Recap.Cells("B" + IndexClientRecap.ToString).Hyperlink = New ExcelHyperLink(Dt.Rows(ILigne).Item("Client").ToString.Replace(" ", "_").Replace("&", "&") + "!A1", Dt.Rows(ILigne).Item("Client").ToString)

 

How to have a "&" in the name of a tab

Regards,

Fabrice