Need way to change document spacing thru vba in word doc

[HunterN]

Hi,

I have an application that (through VBA) opens an existing excel workbook and puts it into a Word document. This works just fine. But, since I have just recently converted to Office 2007 I find that the line spacing in 2007 is bigger than previous Word. I recorded a macro inside Word 2007 to make the spacing 1 line. This is what the recorder showed:

WordBasic.OpenOrCloseParaBelow

I stuck this inside the current macro I have that creates the Word document from Excel, but nothing happened. It didn't give an error and it didn't change the spacing. I think it is because I did not have anything selected inside the document. This is actually a table inside Word. How do I select the document (table) through VBA in order for this spacing command to work?

Thanks for any examples.

Nancy

 

[HunterN]

OK - here is the two lines that I needed.

wrdApp.Selection.WholeStory
WordBasic.OpenOrCloseParaBelow

Hope this helps someone else.

: )