Add a vbCrLF

I want to exporting some data from Excel 2010 to specific bookmarks in a Word document (template)

The first bookmark already exist in the Word document. The next couple of bookmarks do not exist already because the are different each time. (user can decide by a macro buttons in excel with bookmarks should be added.)

Starting my marco in excel, it opens the document and it finds the basic bookmark. The cursor is put on the right place. But then I can't figure out what should be the code to add a vbCrLF to get the cursor on the next blank line in that Word document.
I'am trying differt code with Chr10 or vbCrLF on the same code row or a new one but I can't find the solution.



Complete function code, so far:

Dim wrdApp As Object
Dim wrdDoc As Object
Dim oRng As Object

Dim wdDoc As Word.Document

On Error Resume Next
Set wrdApp = GetObject(, "Word.Application")
If Err Then
Set wrdApp = CreateObject("Word.Application")
End If
On Error GoTo 0

wrdApp.Visible = True

Set wrdDoc = wrdApp.Documents.Add(Template:="C:\local\DD.dotx")
Set oRng = wrdDoc.Paragraphs(1).Range

With wrdApp
'.Documents.Open "C:\local\DD.dotx"
wrdApp.Selection.Goto What:=wdGoToBookmark, Name:="DD"

End With

End Sub


Does anybody know a solution for this?

Please Login or Register  to view this content.

Norie,

Thanks for your answer.
Unfortunatly it does not functioning.

I recieve an error:
Error 438
This propterty of methode is not supported by this object

That does'nt work and I recieve no error.

I tested it and

Please Login or Register  to view this content.

is function well. Only the last part, replace the "123" for a code that gives a vbCrLF (Chr13) is the problem.

Norie,

Your code works fine but is not what I 'am looking for.

My Word document looks like:

"bla bla
I

bla...bla...


The "I" is the basis bookmark. When I run the macro then the cursor is blinking there. Thats fine. But now I like to insert a new row there and add a new bookmark in front off that line.

After insert an new line there, the result should be that there are two line's with both a bookmakers sign on the first position. The first bookmakers sign was there already, the second is added by the macro.

"bla..bla.."

I
I

"bla..bla..

yes that is what my goal is.

Pherhaps my thoughts on controlling bookmarks (add/remove) in a Word document from macro's in excel is not possible.

Thats why I try to find another solution.
Is is possible to create a macro in excel which delete empty tables in a Word document. I read many artikels online on how to delete empty rows but I looking for a solution to delete complete tables.
I have a Word document with 5 different tables. This tables are filled with data exported from Excel. Each table has some bookmarks in it. Depending on the user, while working in excel, one or more tables are filled with the data. The empty tables should be removed.

Is this possible?

Thanks for your reply.

Do you have sample macro for that. I look on Internet, see some code but it does not function in a test.
I also wonder how I can find the unigue name of a table in Word. When I see the properties, there is no name or something what indicates its unique id where I can refer to in a macro.

I see on internet some code but testing it and make some changes and test again give me errors. I am no expert in VBA, so do you have a basic code for this goal. Then I can start from there creating it.