CODEWITHSUNDEEP
excelvba
sw_embed
sw_embed

Reputation: 199

Print integer as String in Visual Basic

In Visual Basic,

I have the below code written but I have problem printing it in string format although it is type integer. I am trying to save time by not repeating the same thing for over 30 numbers.

Dim line As Integer
line = 0

Sub DisplayModule(page As Integer, line As Integer)
maxline = 100    
For line = 0 To maxline
Print #page, Spc(6); "Display in String"
Print #page, Spc(8); "{"
Print #page, Spc(10); """line"""
Print #page, Spc(8); "}"
Print #page, Spc(8); "next"
Next
End Sub

Problem - It is displaying :

Display in String
{
 line
}
"next line please"
{
 line
}
.
.

I want it to display like this with "" :

Display in String
{
 "0"
}
"next line please"
{
 "1"
}
.
.

I couldn't find anything similar like this on SO. Thanks for your help.

Upvotes: 4

Views: 5610

Answers (2)

kb_sou
kb_sou

Reputation: 1057

Try 

Dim line As Integer
line = 0

Sub DisplayModule(page As Integer, line As Integer)
   maxline = 100    
   For line = 0 To maxline
      Print #page, Spc(6); "Display in String"
      Print #page, Spc(8); "{"
      Print #page, Spc(10); """" & line & """"
      Print #page, Spc(8); "}" 
      Print #page, Spc(8); "next"
   Next
End Sub

Upvotes: 2

Siddharth Rout
Siddharth Rout

Reputation: 149287

Try this 

Print #page, Spc(10); chr(34) & line & chr(34)

Upvotes: 5

Related Questions