vb to word problem

[amit_m04]

Hii

I have a program in vb in which there is a multiline textbox and the text in the text box are like after every line there is a blank line and then the other line of text and soo on.
when i transfer the data from that text box into a word file i get small boxes before and after the line.
how can i remove those small boxes..?

[trisuglow]

The small boxes represent carriage return and line feed characters (ASCII 13 and 10 respectively). Use Replace$() on the string to get rid of them.

[amit_m04]

could you tell me where to use this Replace$() and on which string.
is it while transfering the data from vb to word or where should i use it..?

[RobDog888]

Usse it in your code that transfers the data to Word. Post you code to see where to place it.

[Static]

post the code u are using to transfer....

[amit_m04]

Hiii

I have attached the files below.
i am transfering the data from the text files into the word file and i have also attached the word file that i get after the data transfer from vb.
and the multiline textbos is text1(7).

[trisuglow]

I'm sorry, I can't reproduce your problem.

Can you make a new project which just has a multiline text box with the kind of data you're talking about and writes the data in the textbox to a Word document when you click a button?

If you get the same problem with this new project then post the code for it.

[amit_m04]

Hii

i have a multiline textbox i:e Text1(7) and the data that comes in that textbox is from an access database Example:

the data is in access database & i take that data into an array and split it and then put that in the multiline textbox with a crlf at the end and thats hows there is a line in the textbox and then a blank line and then again a line of text.

Then to transfer the data to a work file in the program it finds a word "bkH" & replaces that word with the data that is in the Text1(7) [multiline textbox] thats it.

And this program that is attached is called when i click on the save button.
pls help me regarding this its very urgent or tell me how can i transfer the data to the word file from vb.

[trisuglow]

This works for me. What are you doing different that causes a problem?

Private Sub Command1_Click()
  Set appwd = CreateObject("Word.Application")
  appwd.Visible = True
  appwd.Documents.Open "c:\others.doc"
  appwd.selection.typetext Text1.Text
  appwd.ActiveDocument.SaveAs "c:\others.doc"
  appwd.ActiveDocument.Close
  appwd.Quit
  Set appwd = Nothing
  
End Sub
 
Private Sub Form_Load()
  Text1.Text = Text1.Text & "line1" & vbCrLf
  Text1.Text = Text1.Text & "line2" & vbCrLf
  Text1.Text = Text1.Text & "line3" & vbCrLf
  Text1.Text = Text1.Text & "line4" & vbCrLf
  Text1.Text = Text1.Text & "line5" & vbCrLf
  Text1.Text = Text1.Text & "line6" & vbCrLf
  Text1.Text = Text1.Text & "line7" & vbCrLf
End Sub

[amit_m04]

this will be only for 1 textbox where as i have 8 textbox's and i want to transfer the data from all the textbox's to the word file then in that case how will it work.

[trisuglow]

The example I've given is a response to your initial question. You said you had a problem with "small boxes" when you transferred data from a multiline textbox to Word.

I want to understand why this works for me but not in your application.

Are you asking for a complete solution now?

[amit_m04]

yes if you could pls give me a complete solution for then that would be gr8

[amit_m04]

hii trisuglow

the code that u gave me did worked but how can i make it work with more then 1 text box.
could you pls help me complete solution.