question on word vba .Paragraphs.SpaceBefore = 0

[jamilm]

Gurus,

i am using excel vba with word object library to create a memo from the ranges in excel cells.

now i am typing some texts and when i moved from my first typetext to the second with type paragraph then there is a considerablly big space between first line and the second line. i can remove that via word document manually "Line and Paragraph Spacing" on the dropdown "Remove Space After Paragraph" however i am trying to perform the same manual thing through the VBA code. i searched through Google and i found in some forums that either .Paragraphs.SpaceBefore = 0 or .Paragraphs.SpaceAfter = 0 which work, however i tried and still did not work. i do not know where to put the .Paragraphs.SpaceAfter = 0 either before the second text or after it. any help would be appreciated.

P.S when i use record macro to check how macro is recording the code. unfortunately recording macro does not record any code for "Line and Paragraph Spacing" on the dropdown "Remove Space After Paragraph".

With WordApp
            .Documents.Add
            With .Selection
.TypeText Text:="Project Advances and Project Expenses"
.TypeParagraph
.TypeText Text:="Project Budget & Project Cash"

 

[NdNoviceHlp]

HTH. Dave

With WordApp
.Documents.Add
With .Selection
.TypeText Text:="Project Advances and Project Expenses" & vbCrLf
.TypeParagraph
.TypeText Text:="Project Budget & Project Cash" & vbCrLf

 

[jamilm]

thanks. but it did not work

HTH. Dave

With WordApp
.Documents.Add
With .Selection
.TypeText Text:="Project Advances and Project Expenses" & vbCrLf
.TypeParagraph
.TypeText Text:="Project Budget & Project Cash" & vbCrLf

 

[NdNoviceHlp]

There's no space when I use the code. Are there any tab settings or styles in the document? Beyond that I've got no idea why it doesn't work for you. Good luck. Dave