Problems formatting a Word 2010 table using VBA

macropod · #1 05-12-2019, 05:10 PM

Quote:

Originally Posted by sts023

OK, I realise that - the issue is that I'm doing what works when the macro recorder is used, but it doesn't work when transferred to vba. I'm trying to find VBA to do what the macro recorder does when it is used to record my actions.

Whatever the macro recorder records is VBA - and it's generally pretty reliable. Conversely, it's as dumb as a box of rocks and would be incapable of generating code as complex as that in your first post. There are also many actions it won't record.

Quote:

Originally Posted by sts023

Thats the problem - without the recorder I'm not well enough versed in Word VBA to know what the "native" commands are.

Time to get into the Word Object model and start learning.

As for the immediate problem, edit your With tblDiner ... End with block by adding:

Code:

  With tblDiner
    ' ...
    .Range.ParagraphFormat.SpaceAfter = 0
    .Rows.HeightRule = wdRowHeightAuto
  End With

Better than using '.ParagraphFormat.SpaceAfter = 0' would be to apply an appropriate paragraph Style to the table.

sts023 · #2 05-13-2019, 03:52 AM

Thanks macropod - I know I need to investigate the Word object further - I rather stupidly assumed there would be more parallels with Excel in terms of methods of achieving a goal: I should have remembered it's a Microsoft offering!

Your suggested code works a treat - thanks for that.

And thanks to all who replied (or considered replying) - it's nice to feel that I'm part of a community (or is it just that I've been in I.T. for too long?)...

macropod · #3 05-13-2019, 05:37 AM

Quote:

Originally Posted by sts023

I rather stupidly assumed there would be more parallels with Excel in terms of methods of achieving a goal: I should have remembered it's a Microsoft offering!

The differences are because of the nature of each program rather than being something arbitrary. With Word, for example, cells in the same column of a table can have different widths - something that's impossible in Excel.

sts023 · #4 05-13-2019, 05:47 AM

Yes - I guess it's also something to do with terminology - I tend to think of a "cell" in Excel terms, and I'm still unfamiliar with some of the MSWord concepts like WholeStory, and I get wary of thinking of them in too "English" a way for fear of misleading myself.
I guess I'll just have to keep on learning, even though I retired 8 years ago.
Still, they say it keeps you young!....

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Does sending a W10 Word 2016 template to someone with a W7 Word 2010 system cause problems?	dianahbr	Word	4	03-06-2018 02:27 PM
Word 2011 for Mac - problems with table of contents	tepose	Word	1	09-28-2014 03:36 PM
Many Corruption Problems Word 2010	sleake	Word	2	07-25-2013 07:20 PM
Copy & paste problems Word 2010	pjm333	Word	2	02-13-2013 04:52 AM
Spacing problems with word 2010	Microsoftenquirer1000	Word	5	06-25-2012 12:01 PM