Click here to Skip to main content
15,901,712 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Send Null/Nothing to POS printer Pin
melvintcs9-Dec-11 0:02
melvintcs9-Dec-11 0:02 
GeneralRe: Send Null/Nothing to POS printer Pin
εїзεїзεїз11-Dec-11 22:42
εїзεїзεїз11-Dec-11 22:42 
QuestionCommunication with Panasonic PABX phone [modified] Pin
FuzMic20-Jul-10 18:55
FuzMic20-Jul-10 18:55 
AnswerRe: Communication with Panasonic PABX phone Pin
DaveAuld22-Jul-10 9:02
professionalDaveAuld22-Jul-10 9:02 
GeneralRe: Communication with Panasonic PABX phone [modified] Pin
FuzMic22-Jul-10 17:55
FuzMic22-Jul-10 17:55 
QuestionCheckbox in datagridview Pin
waner michaud20-Jul-10 9:45
waner michaud20-Jul-10 9:45 
AnswerRe: Checkbox in datagridview Pin
Scubapro20-Jul-10 19:31
Scubapro20-Jul-10 19:31 
QuestionReplacing & during conversion of Excel to XML using VBA Pin
priyaahh20-Jul-10 6:01
priyaahh20-Jul-10 6:01 
Hi Friends,

I am converting an excel to xml using vba. THere this excel data having &. But when converting & to xml it is giving error. So I am using the following funtion to replace &.

Function RemoveAmpersands(AnyStr As String) As String
Dim MyPos As Integer
' replace Ampersands (&) with plus symbols (+)
MyPos = InStr(1, AnyStr, "&")
Do While MyPos > 0
Mid(AnyStr, MyPos, 1) = "+"
MyPos = InStr(1, AnyStr, "&")
Loop
End

But the above function replacing with +. But I wanted to display in the browser as & only. Kindly Help.

Regards,
Priya.
AnswerRe: Replacing & during conversion of Excel to XML using VBA Pin
riced20-Jul-10 6:53
riced20-Jul-10 6:53 
GeneralRe: Replacing & during conversion of Excel to XML using VBA Pin
priyaahh20-Jul-10 20:04
priyaahh20-Jul-10 20:04 
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 
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 

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.