Click here to Skip to main content
15,922,166 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Replacing & during conversion of Excel to XML using VBA Pin
priyaahh21-Jul-10 1:24
priyaahh21-Jul-10 1:24 
AnswerRe: Replacing & during conversion of Excel to XML using VBA Pin
DaveAuld20-Jul-10 7:09
professionalDaveAuld20-Jul-10 7:09 
GeneralRe: Replacing & during conversion of Excel to XML using VBA Pin
priyaahh20-Jul-10 20:02
priyaahh20-Jul-10 20:02 
AnswerRe: Replacing & during conversion of Excel to XML using VBA Pin
AnnieMacD20-Jul-10 13:27
AnnieMacD20-Jul-10 13:27 
GeneralRe: Replacing & during conversion of Excel to XML using VBA Pin
priyaahh20-Jul-10 20:00
priyaahh20-Jul-10 20:00 
GeneralRe: Replacing & during conversion of Excel to XML using VBA Pin
AnnieMacD21-Jul-10 2:42
AnnieMacD21-Jul-10 2:42 
GeneralRe: Replacing & during conversion of Excel to XML using VBA Pin
priyaahh21-Jul-10 23:36
priyaahh21-Jul-10 23:36 
GeneralRe: Replacing & during conversion of Excel to XML using VBA Pin
AnnieMacD22-Jul-10 4:34
AnnieMacD22-Jul-10 4:34 
OK, here are two code snippets that illustrate what you need.

<p>
       You can find <a href="http://go.microsoft.com/fwlink/?LinkID=152368&amp;clcid=0x409"
           title="MSDN ASP.NET Docs">documentation on ASP.NET at MSDN</a>.
   </p>

After the 152368 you see ampersand(&), letter a, letter m, letter p then semi-colon(;)? That is what is required in place of the &. This will do the replacement for you:

Dim newStr As String = oldStr.Replace("&", "&amp;")

It’s not because things are difficult that we do not dare, it’s because we do not dare that things are difficult. ~Seneca

QuestionIIF strange behaviour Pin
ddecoy19-Jul-10 21:59
ddecoy19-Jul-10 21:59 
AnswerRe: IIF strange behaviour Pin
DaveAuld19-Jul-10 22:52
professionalDaveAuld19-Jul-10 22:52 
AnswerRe: IIF strange behaviour Pin
Luc Pattyn19-Jul-10 23:12
sitebuilderLuc Pattyn19-Jul-10 23:12 
GeneralRe: IIF strange behaviour Pin
Dalek Dave19-Jul-10 23:28
professionalDalek Dave19-Jul-10 23:28 
GeneralRe: IIF strange behaviour Pin
ddecoy20-Jul-10 0:10
ddecoy20-Jul-10 0:10 
AnswerRe: IIF strange behaviour Pin
Dave Kreskowiak20-Jul-10 2:04
mveDave Kreskowiak20-Jul-10 2:04 
GeneralRe: IIF strange behaviour Pin
ddecoy20-Jul-10 2:11
ddecoy20-Jul-10 2:11 
AnswerRe: IIF strange behaviour Pin
Luc Pattyn20-Jul-10 2:15
sitebuilderLuc Pattyn20-Jul-10 2:15 
GeneralRe: IIF strange behaviour Pin
Eddy Vluggen20-Jul-10 2:27
professionalEddy Vluggen20-Jul-10 2:27 
AnswerRe: IIF strange behaviour Pin
ddecoy20-Jul-10 3:14
ddecoy20-Jul-10 3:14 
GeneralRe: IIF strange behaviour Pin
Dave Kreskowiak20-Jul-10 3:41
mveDave Kreskowiak20-Jul-10 3:41 
AnswerRe: IIF strange behaviour Pin
Dave Doknjas20-Jul-10 12:00
Dave Doknjas20-Jul-10 12:00 
AnswerThe problem is with the CType, not the IIf Pin
Gregory Gadow22-Jul-10 3:55
Gregory Gadow22-Jul-10 3:55 
Questionhow to make treenode style changed when mouse over it ? Pin
sanyexian19-Jul-10 14:47
sanyexian19-Jul-10 14:47 
AnswerRe: how to make treenode style changed when mouse over it ? Pin
Abhinav S19-Jul-10 18:34
Abhinav S19-Jul-10 18:34 
GeneralRe: how to make treenode style changed when mouse over it ? Pin
sanyexian19-Jul-10 19:51
sanyexian19-Jul-10 19:51 
Questionadding tab control in VB6 Pin
Sakhalean19-Jul-10 3:09
Sakhalean19-Jul-10 3:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.